Re: Retrieving trigger bodies from USER_TRIGGERS

Dan,

You are missing the

set long 20000

You will still need the arraysize and maxdata as well.

Because the text of the trigger is stored in a long column, this defaults to 80 bytes, and hence you are only getting the initial portion of the text.

Andrew

Dan Hopkins wrote:

> Not sure if this is the correct group(s) but ... I'm having trouble
> retrieving a trigger body from the USER_TRIGGERS table. I get the first
> line or so, but that's all I get. I've looked at various options to SET
> (MAXDATA, ARRAY_SIZE etc) but to no avail. Am I missing something
> obvious ?
>
> Could someone point me in the right direction ?
>
> Thanks,
> --
> Dan Hopkins
> dan_at_ukonline.net
Received on Wed Apr 21 1999 - 07:51:42 CDT