Where is the source code for a trigger kept?
Date: 1997/12/11
Message-ID: <memo.19971211194249.20501B_at_robsoft.cix.co.uk>#1/1
Hi. I've found where to get the source code for procedure from (the
sys.source$ table, I can correlate with an obj#, from the sys.procedure$
table etc etc - no problems).
But where is the code for a trigger kept?
All I seem to get back from sys.trigger$ is stuff about the definition and
where clauses - fair enough. The ACTION column looks useful but seems to
contain stuff just up to the BEGIN statement.
Am I missing something here? Does ACTION actually contain everything that
I want but SQL*Plus is truncating what I'm getting back?
There is also a column called BASOBJECT but that doesn't seem to be a
pointer into SOURCE$.
Can anyone tell me where the source code for a trigger is actually kept?
Thanks in advance
rob_at_xxrobsoft.compulink.co.uk
(remove the xx for my email address)
Received on Thu Dec 11 1997 - 00:00:00 CET