Re: Help: Trigger Problem

In <4s3in1$m6i_at_lal.interserv.net>, croys_at_smart.net (Chris) writes:
>
>I created a trigger and it gets created just fine. but when I try to view the body
>of the trigger in the all_triggers and only a couple of lines show up of the body.
>It cuts off right in the middle of a variable. The trigger doesn't seem to be
>working either but it compiles just fine. Any idea what the problem might be?
>Thanks in advance.
>
>Chris
>croys_at_smart.net

Col all_triggers.trigger_body is a long datatype.

You are only seeing part of your trigger body because your long is probably set to default of 80 (In SQL issue "show long" ). To increase the amount of long data returned by a select statement use the set long xxxxxx command. For example:

SQL> set long 32000
SQL> select trigger_body from all_triggers where trigger_name='YOUR_TRIGGER';

M.Landa Received on Fri Jul 12 1996 - 00:00:00 CEST