From: rprendin@magi.com (Robert Prendin)
Subject: Re: Where is the source code for a trigger kept?
Date: 1997/12/12
Message-ID: <3490be67.5591450@news.istar.ca>#1/1
References: <memo.19971211194249.20501B@robsoft.cix.co.uk>
NNTP-Posting-Date: Thu, 11 Dec 1997 23:31:42 EST
Newsgroups: comp.databases.oracle



select trigger_body from all_triggers;

rob@xxrobsoft.compulink.co.uk (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?
>
>Thanks in advance
>
>rob@xxrobsoft.compulink.co.uk
>(remove the xx for my email address)