Re: DB Triggers Body Text

Yousef Kanani wrote:
>
> Hi There,
> Can someone tell me how to get the logic(program body) of a db_trigger.
> when I extract the data from DB_TRIGGERS view it only gives me the
> DECLARE section. here is waht I did
> select trigger_name,trigger_body, description, where_clause
> from db_triggers;
> It only gives me the first few lines.
>
> Any suggestions?
>
> Thanks In Advance
>
> Yousef - ykanani_at_gbrownc.on.ca

You should be able to issue the SET LONG 200000 to allow yourself to see more data.

-- 
Michael J. Pantaleano <mike.pantaleano_at_ab.com>
Senior Analyst, Software Applications
Allen-Bradley a Rockwell International Company 
The opinions expressed above are not that of the people who pay me.