From: Oliver Critchley <oliver.critchley@no.spam.please>
Subject: Re: Where is the source code for a trigger kept?
Date: 1997/12/12
Message-ID: <34917693.3969@no.spam.please>#1/1
Content-Transfer-Encoding: 7bit
References: <memo.19971211194249.20501B@robsoft.cix.co.uk>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Organization: AIT
Newsgroups: comp.databases.oracle



robsoft wrote:
> 
> 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?

What you want is the "trigger_body" field in "user_triggers" or "all_triggers".

Oliver.