Hi,

I'm seeking some advice. Basically, one of our developers has written
an insert-select statement within a procedure. When the statement is
extracted from the procedure and run in sqlplus it executes in about 30
secs (populated table).

However, when the procedure itself was executed it was still running 2
days later and then generated a RBS segment too small error. During
this time the session was marked as ACTIVE and no exceptions were
thrown by the procedure.

I can't understand why running the same code in a procedure would make
such a difference.
The problem is definitely not linked to permissions.

Does anybody have any suggestions how I can start diagnosing this..

Thanks in advance.
John