RE: How to find PL/SQL code

From: David Barbour <DBarbour_at_connectsouth.com>
Date: Thu, 10 Aug 2000 17:15:08 -0500
Message-Id: <10585.114311@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_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_at_connectsouth.com

-----Original Message-----
From: Jeff Wiegand [mailto:jwiegand_at_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"

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<TITLE>How to find PL/SQL code</TITLE>

<META content="MSHTML 5.00.2314.1000" name=GENERATOR></HEAD>
<BODY>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=038561322-10082000>Jeff,</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=038561322-10082000></SPAN></FONT> </DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN class=038561322-10082000>If the
triggers are in a stored procedure, you can get the text from either dba_source or user_source.</SPAN></FONT></DIV>
<DIV> </DIV>
<P><FONT face=Arial size=2>David A. Barbour</FONT> <BR><FONT face=Arial

size=2>Oracle DBA - ConnectSouth</FONT> <BR><FONT face=Arial 
size=2>512-681-9438</FONT> <BR><FONT face=Arial 
size=2>dbarbour_at_connectsouth.com</FONT> </P>

<BLOCKQUOTE style="MARGIN-RIGHT: 0px">

<DIV align=left class=OutlookMessageHeader dir=ltr><FONT face=Tahoma size=2>-----Original Message-----<BR><B>From:</B> Jeff Wiegand [mailto:jwiegand_at_ancept.com]<BR><B>Sent:</B> Thursday, August 10, 2000 10:45 AM<BR><B>To:</B> Multiple recipients of list ORACLE-L<BR><B>Subject:</B> How to find PL/SQL code<BR><BR></DIV></FONT> <P><FONT size=2>Hello</FONT> </P>
<P><FONT size=2>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?</FONT></P>
  <P><FONT size=2>Thanks for your help.</FONT> </P>
  <P><FONT size=2>Jeff</FONT> </P></BLOCKQUOTE></BODY></HTML>

Received on Thu Aug 10 2000 - 17:15:08 CDT