Message-Id: <10585.114284@fatcity.com> From: "Thomas L. Harleman" Date: Thu, 10 Aug 2000 13:14:53 -0500 Subject: RE: How to find PL/SQL code This is a multi-part message in MIME format. ------=_NextPart_000_001F_01C002CC.F8BD18A0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit How to find PL/SQL codeIn the table ALL_TRIGGERS you'll notice that TRIGGER_BODY is a LONG data type. If you are using SQL*Plus you'll need to SET LONG 10000 Tom Harleman 11080 Willowmere Dr. Indianapolis, IN 46280 317-844-2884 Home 317-843-9122 Home Office -----Original Message----- From: root@fatcity.com [mailto:root@fatcity.com]On Behalf Of Jeff Wiegand 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_000_001F_01C002CC.F8BD18A0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable How to find PL/SQL code
In the=20 table ALL_TRIGGERS you'll notice that TRIGGER_BODY is a LONG data=20 type.
If you=20 are using SQL*Plus you'll need to SET LONG 10000
 

Tom Harleman
11080 Willowmere Dr.
Indianapolis, = IN=20 46280
317-844-2884 Home
317-843-9122 Home Office

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

Hello

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

Thanks for your help.

Jeff