Message-Id: <10585.114311@fatcity.com> From: David Barbour Date: Thu, 10 Aug 2000 17:15:08 -0500 Subject: RE: How to find PL/SQL code This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01C00318.717734B0 Content-Type: text/plain; charset="iso-8859-1" Jeff, If the triggers are in a stored procedure, you can get the text from either dba_source or user_source. David A. Barbour Oracle DBA - ConnectSouth 512-681-9438 dbarbour@connectsouth.com -----Original Message----- From: Jeff Wiegand [mailto:jwiegand@ancept.com] Sent: Thursday, August 10, 2000 10:45 AM To: Multiple recipients of list ORACLE-L Subject: How to find PL/SQL code Hello We have several triggers that have been modified. Unfortunately, the modifications weren't saved, but they are reflected in the database. How can I get Oracle to output the code of the triggers. I select on user_triggers, or all_triggers, using trigger_name and trigger_body columns, but only part of the code is outputted to the screen. How can I get all of it? Thanks for your help. Jeff ------_=_NextPart_001_01C00318.717734B0 Content-Type: text/html; charset="iso-8859-1" How to find PL/SQL code
Jeff,
 
If the triggers are in a stored procedure, you can get the text from either dba_source or user_source.
 

David A. Barbour
Oracle DBA - ConnectSouth
512-681-9438
dbarbour@connectsouth.com

-----Original Message-----
From: Jeff Wiegand [mailto:jwiegand@ancept.com]
Sent: Thursday, August 10, 2000 10:45 AM
To: Multiple recipients of list ORACLE-L
Subject: How to find PL/SQL code

Hello

We have several triggers that have been modified. Unfortunately, the modifications weren't saved, but they are reflected in the database. How can I get Oracle to output the code of the triggers. I select on user_triggers, or all_triggers, using trigger_name and trigger_body columns, but only part of the code is outputted to the screen. How can I get all of it?

Thanks for your help.

Jeff