From: "Frank Leenders" Subject: Re: Where is the source code for a trigger kept? Date: 1997/12/12 Message-ID: <66s56r$jtu$1@news.Kijfhoek.NL.net>#1/1 References: X-MimeOLE: Produced By Microsoft MimeOLE V4.71.1712.3 Organization: NLnet Newsgroups: comp.databases.oracle you should use all_triggers instead of the tables you mentioned. Frank robsoft wrote in message ... >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@xxrobsoft.compulink.co.uk >(remove the xx for my email address)