RE: How to find PL/SQL code

From: Thomas L. Harleman <tharleman_at_iquest.net>
Date: Thu, 10 Aug 2000 13:14:53 -0500
Message-Id: <10585.114284@fatcity.com>

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_at_fatcity.com [mailto:root_at_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

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>How to find PL/SQL code</TITLE>
<META content=3D"text/html; charset=3Diso-8859-1" =
http-equiv=3DContent-Type>
<META content=3D"MSHTML 5.00.2919.6307" name=3DGENERATOR></HEAD>
<BODY>
<DIV>In the=20
table ALL_TRIGGERS you'll notice that TRIGGER_BODY is a LONG data=20 type.</DIV>
<DIV>If you=20
are using SQL*Plus you'll need to SET LONG 10000</DIV>
<DIV> </DIV>
Tom Harleman 11080 Willowmere Dr. Indianapolis, =
IN=20
46280 317-844-2884 Home 317-843-9122 Home Office 
<BLOCKQUOTE style=3D"MARGIN-RIGHT: 0px">
 <DIV align=3Dleft class=3DOutlookMessageHeader dir=3Dltr>-----Original Message----- From: root_at_fatcity.com=20 [mailto:root_at_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 </DIV>
 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?</FONT></P>
  <P><FONT size=3D2>Thanks for your help.</FONT> </P>
  <P><FONT size=3D2>Jeff</FONT> </P></BLOCKQUOTE></BODY></HTML>

Received on Thu Aug 10 2000 - 13:14:53 CDT