Skip to Main Content
Forums

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!

How to get SP body inside Database Trigger

AliBudakOct 4 2013 — edited Oct 7 2013

Hi,

I have a Database Trigger (AFTER CREATE) and I wish to retrieve newly created Stored Procedure's body. I tried to use DBMS_METADATA.GET_DDL(DICTIONARY_OBJ_TYPE,DICTIONARY_OBJ_NAME,DICTIONARY_OBJ_OWNER) function, but I got this error: ORA-31603 object is not found.

The trigger is created in SYS schema, so there is no problem with SELECT_CATALOG_ROLE privilage. Is there another way to get SP body?

Thanks in advance.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 4 2013
Added on Oct 4 2013
16 comments
867 views