SQL Experts Apply Within

From: Johne_uk <edgarj_at_tiscali.co.uk>
Date: 23 Nov 2005 03:02:25 -0800
Message-ID: <1132742697.094553.174620@g14g2000cwa.googlegroups.com>

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 Received on Wed Nov 23 2005 - 05:02:25 CST