Hi,
Are there any way to decompile or reverse engineer Oracle trigger? Any tools available, any free ones?
Thanks!
views:
73answers:
2
+7
A:
This may be done querying user_triggers or dba_triggers as such:
SELECT trigger_body FROM user_triggers where trigger_name = 'THENAME';
or
SELECT DBMS_METADATA.GET_DDL('TRIGGER','....') FROM DUAL
If the trigger code calls other code that is Wrapped (obsufacted) you will need to unwrap it, see this article or do a google search for "oracle unwrap pl/sql"
You can also use a Oracle managment or development tool to get the trigger source code.
oluies
2010-07-15 14:16:17
SELECT DBMS_METADATA.GET_DDL('TRIGGER','....') FROM DUAL is an alternative.
Gary
2010-07-15 23:49:40
Triggers cannot be wrapped.
Jeffrey Kemp
2010-07-16 05:03:40
Thanks!And to get it from a different user if permissions allow:select trigger_name, status, trigger_body from all_triggers WHERE owner = 'SOMEUSERNAME' ORDER BY trigger_name;
o1e9
2010-07-16 08:09:26
And it seems SQLTools may extract trigger body with not problem, just with a double click.Anyway thanks for the tip!
o1e9
2010-07-16 08:12:51
Jeffery - triggers can call code that ar wrapped
oluies
2010-07-16 09:05:46
+1
A:
Sql*plus should be able to solve that. You can query the system tables to get the body text.
Chris Kimpton
2010-07-15 14:16:52