Re: spooling TRIGGER_BODY

JR wrote:

> When I try to spool a trigger body it wraps the characters past 80
> characters to the next line. How can I prevent this from happening?
> The set line command doesn't seem to help.
>
> See how the create_date statement is chopped in the example below :
>
> sqlplus> set line 200
> sqlplus> set long 10000
> sqlplus> spool file.trg.sql
> sqlplus> select trigger_body from user_triggers where trigger_name =
> 'SAMPLE';
>
> TRIGGER_BODY
> --------------------------------------------------------------------------------
> begin
> if :new.tran_code in (20,30) then
> insert into roll_forward_av_cost_pool
> (sku,location,tran_code,cost_pool,crea
> te_date) values
> (:new.sku, :new.location, :new.tran_code, :new.cost_pool,
> sysdate);
> end if;
> end;

Where did you find your sytax for SQL*Plus?

SQL> set linesize 200

Might also want to add trimspool and other commands. You can find a list of the most useful at http://www.psoug.org click on Morgan's Library
click on SQL*Plus

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)