OraFAQ Forum: Server Administration » How to display full procedure body of triggers?

Home » RDBMS Server » Server Administration » How to display full procedure body of triggers?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to display full procedure body of triggers? [message #375135]

Mon, 30 July 2001 14:19

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

Report message to a moderator

Re: How to display full procedure body of triggers? [message #375136 is a reply to message #375135]

Mon, 30 July 2001 14:50

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.

Report message to a moderator

Re: How to display full procedure body of triggers? [message #375138 is a reply to message #375136]

Mon, 30 July 2001 15:02

holly
Messages: 3
Registered: July 2001

Junior Member

Thanks Jon, it now works!

Report message to a moderator

Previous Topic:	Re: varchar2 to number conversion
Next Topic:	how to find

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jul 05 10:25:48 CDT 2024