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!

ORA-06512: at "SYS.DBMS_SYS_SQL", line 826

603350May 19 2008 — edited May 20 2008

Dear All,

These errors are notised in trace file.
Can you Check and help me to solve this issue.
I dont have code for that check_and_drop procedure.It is wrapped procedure.
But it drop's given object if it exists.

Errors in file /oradump/NEXTPD/bdump/nextpd_j000_8177.trc:
ORA-12012: error on auto execute of job 15777
ORA-04043: object DYN_PROP_042708033535_694 does not exist
ORA-06512: at "SYS.DBMS_SYS_SQL", line 826
ORA-06512: at "SYS.DBMS_SQL", line 39
ORA-06512: at "D.ACT_DINAMIC_SQL_0", line 10
ORA-06512: at "D.CHECK_AND_DROP", line 20
ORA-06512: at "D.PROPORT_SPLIT", line 488
ORA-06512: at line 1

Best Regards
Lakshmi Narayana

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 17 2008

Added on May 19 2008

4 comments

3,540 views