Re: Help: Trigger Problem

From: Dick Allie <dallie_at_ionet.net>
Date: 1996/07/12
Message-ID: <31E66FF5.4760_at_ionet.net>#1/1


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

Original text of this message