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.
>
>

Yousef,

The text of a database trigger (TRIGGER_BODY) is stored in the database as type LONG. The default width for LONGs in SQL*Plus is 80 bytes. In order to retrieve the full text of the trigger, you'll first need to make the width for LONGs sufficiently large. At the SQL> prompt type SET LONG 10000 (or other reasonably large numeric value)<CR>. Then enter your query.

hope this helps,

regards,
Chuck

-- 
*****************************************************************************
*
*   Chuck Wolfe                         Phone: (703)838-9720
*   Senior Consultant                   e-mail:  cwolfe_at_ix.netcom.com (Home)
*   NDC Group, Inc                               cwolfe_at_ndcinc.com    (Work)
*   625 Slaters Lane, 
*   Suite 102
*   Alexandria, VA 22314
* 
*   All the usual discalimers apply, except where otherwise indicated...
****************************************************************************