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!

SYSTEM.AD_DDL "no data found" exception

548336Dec 6 2006 — edited Dec 8 2006

Hi,

I am facing an issue while trying to create a pl/sql object using the SYSTEM.create_plsql_object procedure. I have created the body with system.build_statement and after all the statements, make a call to SYSTEM.create_plsql_object to created the pl/sql object.

I am getting the following error when I try to execute this code.

06-DEC-2006 01:51:01
ORA-01403: no data found
ORA-06512: at "SYSTEM.AD_DDL", line 2712
ORA-06512: at "SYSTEM.AD_DDL", line 2671
ORA-01403: no data found

Not able to figure out the problem.

Thanks,
Sharad

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 5 2007

Added on Dec 6 2006

5 comments

546 views