How to find PL/SQL code

From: Jeff Wiegand <jwiegand_at_ancept.com>
Date: Thu, 10 Aug 2000 09:41:48 -0500
Message-Id: <10585.114265@fatcity.com>

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_01C002D9.1DBEE150
Content-Type: text/plain;

charset="iso-8859-1"

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_01C002D9.1DBEE150
Content-Type: text/html;

charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2650.12">
<TITLE>How to find PL/SQL code</TITLE>
</HEAD>
<BODY>

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


</BODY>
</HTML>
Received on Thu Aug 10 2000 - 09:41:48 CDT