SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

UTL_FILE error? - ORA-20001: ORA-0000: normal, successful completion

440837May 23 2005 — edited May 26 2005

Hi,

I wrote a procedure and am getting the following error message about 20 minutes into the processing:

*
ERROR at line 1:
ORA-20001: ORA-0000: normal, successful completion
ORA-06512: at "APPHARRIS.P_HARRIS_BULK_COLLECT", line 502
ORA-06512: at line 1

I have a fairly large amount of data that gets processed before getting this message. I am using the UTL_FILE package for output and it appears the exception flags with the 'WHEN OTHERS' error (from line 502 of my code). I have tried searching for a description/answer for that sqlcode # to correct it but cannot find much about it. Does anyone know what might cause this error and how to possibly fix it? Any insight would be greatly apprciated.

Thanks,
Eric

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 23 2005

Added on May 23 2005

4 comments

1,613 views