Re: Stored Procedure Help

From: DA Morgan <damorgan_at_exesolutions.com>
Date: Fri, 14 Feb 2003 08:43:52 -0800
Message-ID: <3E4D1CC8.FBC2DEB6@exesolutions.com>

Aaron Rouse wrote:

> Thanks, Andrew's select statement is working since I tested it outside
> of the stored procedure. However when running the SP it ends up
> hanging just like my prior one did. We are running 8i here, I believe
> 8.1.7

Inside the cursor loop put the following code:

i := i+1;
INSERT INTO audit_tab
VALUES
(TO_CHAR(i) || '-' || SAPORG_NEW);
COMMIT; Watch the audit table from another session. That will answer the question as to wheher it is running or hanging.

Daniel Morgan Received on Fri Feb 14 2003 - 10:43:52 CST