918440 wrote:This forum is for SQL*PLUS issues. Yours is a detailed situation with a stored procedure and you will get a better, faster answer in the SQL and PL/SQL forum.
I have a scheduled loading of stored procedure, its loading normally, but today it is hanging at some step to loading a physical table. this is not the first time for this issue. this issue occurred multiple time recently. it normally occurred after successfully loading multiple times. for this time, procedure loading successful for 24/25/26/27/28/29 Aug 2012. on 30 Aug 2012, its loading hanging at step 2 to loading some physical table. will you please tell me how to check issue cause ? I am not DBA, just a procedure developer. so will you please recommend some method suited for me?
appreciate very much.