trigger source code [message #39072] |
Wed, 12 June 2002 02:42 |
aubry Sylvie
Messages: 1 Registered: June 2002
|
Junior Member |
|
|
how can I see the full trigger_body of a Trigger ?
If I select trigger_body from user_triggers, I just get the 3 first lines
|
|
|
Re: trigger source code [message #39073 is a reply to message #39072] |
Wed, 12 June 2002 04:47 |
Rick Cale
Messages: 111 Registered: February 2002
|
Senior Member |
|
|
That is because trigger_body is declared as long.
If you do SET LONG <some big number> you will see
complete body. Do SET LONG 10000 then select * from
user_body where....
|
|
|