From: "Zelli, Brian" <Brian.Zelli@RoswellPark.org>
To: Oracle L <oracle-l@freelists.org>
Date: Thu, 20 Aug 2009 14:17:27 -0400
Subject: package body
Thread-Topic: package body
Message-ID: <6B3493ABEE194842A8EFC3FC3B23DE6A107C8F8FB4@MSXMBCCR2.roswellpark.org>
Accept-Language: en-US
Content-Language: en-US
acceptlanguage: en-US
Content-Type: multipart/alternative; boundary="_000_6B3493ABEE194842A8EFC3FC3B23DE6A107C8F8FB4MSXMBCCR2rosw_"
MIME-Version: 1.0
Sender: oracle-l-bounce@freelists.org
Errors-to: oracle-l-bounce@freelists.org
Precedence: normal
Reply-to: Brian.Zelli@RoswellPark.org
--_000_6B3493ABEE194842A8EFC3FC3B23DE6A107C8F8FB4MSXMBCCR2rosw_
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

I have a developer who asked me what was in the body of a package.   I se=
em to remember being able to look at a package but can't for the life of =
me think of what it was.  I tried dba_source but that spits out a bunch o=
f numbers.  What shows the code?


ciao,
Brian


This email message may contain legally privileged and/or confidential inf=
ormation.  If you are not the intended recipient(s), or the employee or a=
gent responsible for the delivery of this message to the intended recipie=
nt(s), you are hereby notified that any disclosure, copying, distribution=
, or use of this email message is prohibited.  If you have received this =
message in error, please notify the sender immediately by e-mail and dele=
te this email message from your computer. Thank you.
--_000_6B3493ABEE194842A8EFC3FC3B23DE6A107C8F8FB4MSXMBCCR2rosw_
Content-Type: text/html; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; charset=3Dus-ascii"=
>
<META content=3D"MSHTML 6.00.6000.16890" name=3DGENERATOR></HEAD>
<BODY>
<DIV><FONT face=3DArial size=3D2><SPAN class=3D488091418-20082009>I have =
a developer=20
who asked me what was in the body of a package.&nbsp;&nbsp;&nbsp;I seem t=
o=20
remember being able to look at a package but can't for the life of me thi=
nk of=20
what it was.&nbsp; I tried dba_source but that spits out a bunch of=20
numbers.&nbsp; What shows the code?</SPAN></FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV align=3Dleft><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV>&nbsp;</DIV><?xml:namespace prefix =3D o ns =3D=20
"urn:schemas-microsoft-com:office:office" /><o:SmartTagType name=3D"City"=
=20
namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags"></o:SmartTagT=
ype><o:SmartTagType=20
name=3D"place"=20
namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags"></o:SmartTagT=
ype>
<STYLE>st1\:* {
=09BEHAVIOR: url(#ieooui)
}
</STYLE>

<STYLE>@page Section1 {size: 8.5in 11.0in; margin: 1.0in 1.25in 1.0in 1.2=
5in; mso-header-margin: .5in; mso-footer-margin: .5in; mso-paper-source: =
0; }
P.MsoNormal {
=09FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"; =
mso-style-parent: ""; mso-pagination: widow-orphan; mso-fareast-font-fami=
ly: "Times New Roman"
}
LI.MsoNormal {
=09FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"; =
mso-style-parent: ""; mso-pagination: widow-orphan; mso-fareast-font-fami=
ly: "Times New Roman"
}
DIV.MsoNormal {
=09FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"; =
mso-style-parent: ""; mso-pagination: widow-orphan; mso-fareast-font-fami=
ly: "Times New Roman"
}
A:link {
=09COLOR: blue; TEXT-DECORATION: underline; text-underline: single
}
SPAN.MsoHyperlink {
=09COLOR: blue; TEXT-DECORATION: underline; text-underline: single
}
A:visited {
=09COLOR: blue; TEXT-DECORATION: underline; text-underline: single
}
SPAN.MsoHyperlinkFollowed {
=09COLOR: blue; TEXT-DECORATION: underline; text-underline: single
}
SPAN.GramE {
=09mso-style-name: ""; mso-gram-e: yes
}
DIV.Section1 {
=09page: Section1
}
</STYLE>

<DIV class=3DSection1>
<P class=3DMsoNormal align=3Dleft><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial">ciao,</SPAN></P>
<P class=3DMsoNormal><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial">Brian</SPAN></P>
<P class=3DMsoNormal><FONT face=3DArial size=3D2></FONT>&nbsp;</P></DIV><=
/BODY></HTML>


<BR>
This email message may contain legally privileged and/or confidential inf=
ormation.  If you are not the intended recipient(s), or the employee or a=
gent responsible for the delivery of this message to the intended recipie=
nt(s), you are hereby notified that any disclosure, copying, distribution=
, or use of this email message is prohibited.  If you have received this =
message in error, please notify the sender immediately by e-mail and dele=
te this email message from your computer. Thank you. =20


--_000_6B3493ABEE194842A8EFC3FC3B23DE6A107C8F8FB4MSXMBCCR2rosw_--
--
http://www.freelists.org/webpage/oracle-l