Find out which part of the procedure is responsible for your problem.
The easiest way is to query v$sqlarea and find out which one (cursor
or the update) is running and then focus on it.
aaron_rouse_at_yahoo.com (Aaron Rouse) wrote in message news:<a57b6daf.0302140700.2afe273_at_posting.google.com>...
> 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
Received on Fri Feb 14 2003 - 13:48:50 CST
