Table to search text for all triggers, procedures ? 2

[saustin]

Hi, is there a table we can use to search for text which may be contained in a trigger or procedure ?

Thanks, Steve.

 

[SantaMufasa]

Steve,

You can certainly query USER_TRIGGERS and USER_SOURCE, but the column in USER_TRIGGERS with which you want to query is problematic since it is a LONG column and thus "incomparable" while using standard SQL.

Mufasa
(aka Dave of Sandy, Utah, USA)

http://www.dasages.com

Do you use Oracle and live or work in Utah, USA?
Then click here to join Utah Oracle Users Group on Tek-Tips.

 

[saustin]

Hi Mufasa,
Thanks for the reply ! Indeed it is. Have spooled it out with Sql Plus, and also used A2k to view the text.
Did not find any table to use for procedures though.

Thanks, Steve.

 

[SantaMufasa]

Sorry I was not more explicit: USER_SOURCE is the table that contains the code contents of PROCEDURES, FUNCTION, PACKAGES (PACKAGE BODY), et cetera.

Mufasa
(aka Dave of Sandy, Utah, USA)

http://www.dasages.com

Do you use Oracle and live or work in Utah, USA?
Then click here to join Utah Oracle Users Group on Tek-Tips.