Re: Help: Trigger Problem

Chris wrote:
>
> 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

To see all the text of the trigger use sqlplus statement set long 5000 then set arraysize 1 before the select * from all_triggers where ....

The text field of the trigger is a long type field. Default size is 255 when you start sqlplus for viewing purposes.

Hope this helps. Dick Allie, Oklahoma City, OK Dallie_at_ionet.net Received on Fri Jul 12 1996 - 00:00:00 CEST