This content has been marked as final. Show 3 replies
I don't think that it can be done without querying the Data Dictionary tables themselves (would not recommend it since they change by version and the whole security issue). I have ran into the same issue. The "best" solution that I have found is to create a stored procedure to return pieces of them. Is this also very costly. If you find a way to do this I would be very interested.
Thanks for that.
Can you tell me which Dictionary Table I need to query. I've tried looking at the definition of the ALL_TRIGGERS view but was still none-the-wiser.
I agree that it's not an ideal solution, but the application in question is only going to be used internally by development personel. I could also add a check as the app starts so it will only run if connected to a specific version of Oracle (just an idea).
select description, trigger_body from user_triggers a where a.trigger_name = 'BLAH'