Home » RDBMS Server » Server Administration » How to display full procedure body of triggers?
How to display full procedure body of triggers? [message #375135] Mon, 30 July 2001 14:19 Go to next message
holly
Messages: 3
Registered: July 2001
Junior Member
I query the view user_triggers for the column trigger_body, but it only displays the DELCARE part without showing the procedure body(Begin...end), How could I show the procedure(pl/sql) body?
Thanks
Re: How to display full procedure body of triggers? [message #375136 is a reply to message #375135] Mon, 30 July 2001 14:50 Go to previous messageGo to next message
Jon
Messages: 483
Registered: May 2001
Senior Member
It may be that your LONG field is only defaulting to 80. Try "SET LONG = 10000;" before your query.
Re: How to display full procedure body of triggers? [message #375138 is a reply to message #375136] Mon, 30 July 2001 15:02 Go to previous message
holly
Messages: 3
Registered: July 2001
Junior Member
Thanks Jon, it now works!
Previous Topic: Re: varchar2 to number conversion
Next Topic: how to find
Goto Forum:
  


Current Time: Tue Dec 24 06:35:51 CST 2024