RE:

From: Kurth, Michael J. <MJKurth_at_covhealth.org>
Date: Thu, 20 Mar 2003 04:14:02 -0600
Message-Id: <24726.322518@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_01C2EEC9.6E167D40
Content-Type: text/plain;

charset="iso-8859-1"

connect as owner of procedure to sqlplus select * from user_errors where name = 'XXXXX' (XXXXX = procedure name)
-----Original Message-----
From: liujd [mailto:liujd_at_cti.ac.cn]
Sent: Thursday, March 20, 2003 12:34 AM
To: Multiple recipients of list ORACLE-L Subject:

My oracle using version is 8.0.0.5.
Now , I'm programming proc .
When I precompile them and fail. But I can't see what happened .and where the errors are.
So I look carefully for errors in large file. Is there some way to show where the error is .and what the error is . Can you give me your hand .
Thanks in advance!

Privileged/Confidential information may be contained in this message. The information contained in this message is intended only for the use of the recipient(s) named above and their co-workers who are working on the same matter.

The recipient of this information is prohibited from disclosing the information to any other party unless this disclosure has been authorized in advance.

If you are not intended recipient of this message or any agent responsible for delivery of the message to the intended recipient, you are hereby notified that any disclosure, copying, distribution or action taken in reliance on the contents of this message is strictly prohibited. You should immediately destroy this message and kindly notify the sender by reply E-Mail.

Please advise immediately if you or your employer does not consent to Internet E-Mail for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of the firm shall be understood as neither given nor endorsed by it.

------_=_NextPart_001_01C2EEC9.6E167D40
Content-Type: text/html;

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

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML xmlns=3D"http://www.w3.org/TR/REC-html40" xmlns:v =3D=20

"urn:schemas-microsoft-com:vml" xmlns:o =3D=20
"urn:schemas-microsoft-com:office:office" xmlns:w =3D=20
"urn:schemas-microsoft-com:office:word"><HEAD>

<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">

<META content=3DWord.Document name=3DProgId>
<META content=3D"MSHTML 6.00.2800.1106" name=3DGENERATOR>
<META content=3D"Microsoft Word 10" name=3DOriginator><LINK=20
href=3D"cid:filelist.xml_at_01C2EEED.B6AC7310" rel=3DFile-List><!--[if gte mso 9]><xml>
<w:WordDocument>

  <w:SpellingState>Clean</w:SpellingState>
  <w:GrammarState>Clean</w:GrammarState>
  <w:DocumentKind>DocumentEmail</w:DocumentKind>
  <w:EnvelopeVis/>
  <w:PunctuationKerning/>
  <w:DrawingGridVerticalSpacing>7.8 =

磅</w:DrawingGridVerticalSpacing>
=
<w:DisplayHorizontalDrawingGridEvery>0</w:DisplayHorizontalDrawingGridEv=
ery>
=
<w:DisplayVerticalDrawingGridEvery>2</w:DisplayVerticalDrawingGridEvery>=

<w:Compatibility>

   <w:SpaceForUL/>
   <w:BalanceSingleByteDoubleByteWidth/>
   <w:DoNotLeaveBackslashAlone/>
   <w:ULTrailSpace/>
   <w:DoNotExpandShiftReturn/>
   <w:AdjustLineHeightInTable/>
   <w:BreakWrappedTables/>
   <w:SnapToGridInCell/>
   <w:WrapTextWithPunct/>
   <w:UseAsianBreakRules/>
   <w:UseFELayout/>

</w:Compatibility>

  <w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel>
 </w:WordDocument>

</xml><![endif]-->
<STYLE>@font-face {

font-family: 宋
}
@font-face {

font-family: @宋体;
}
@page {mso-page-border-surround-header: no; = mso-page-border-surround-footer: no; }
@page Section1 {size: 612.0pt 792.0pt; margin: 72.0pt 90.0pt 72.0pt = 90.0pt; mso-header-margin: 36.0pt; mso-footer-margin: 36.0pt; = mso-paper-source: 0; }
P.MsoNormal {

TEXT-JUSTIFY: inter-ideograph; FONT-SIZE: 10.5pt; MARGIN: 0cm 0cm 0pt; = FONT-FAMILY: "Times New Roman"; TEXT-ALIGN: justify; mso-font-kerning: = 1.0pt; mso-style-parent: ""; mso-pagination: none; mso-bidi-font-size: = 12.0pt; mso-fareast-font-family: 宋 20307:=20 }
LI.MsoNormal {

COLOR: blue; TEXT-DECORATION: underline; text-underline: single }
SPAN.MsoHyperlink {

COLOR: blue; TEXT-DECORATION: underline; text-underline: single }
A:visited {

COLOR: purple; TEXT-DECORATION: underline; text-underline: single }
SPAN.MsoHyperlinkFollowed {

COLOR: purple; TEXT-DECORATION: underline; text-underline: single }
SPAN.EmailStyle17 {

COLOR: windowtext; FONT-FAMILY: Arial; mso-bidi-font-size: 10.0pt; = mso-fareast-font-family: 宋 20307: ; mso-style-type: = personal-compose; mso-style-noshow: yes; mso-ansi-font-size: 9.0pt; = mso-ascii-font-family: Arial; mso-hansi-font-family: Arial; = mso-bidi-font-family: Arial
}
SPAN.SpellE {

mso-style-name: ""; mso-spl-e: yes
}
SPAN.GramE {

mso-style-name: ""; mso-gram-e: yes
}
DIV.Section1 {

page: Section1
}
</STYLE>
<!--[if gte mso 10]>
<style>

/* Style Definitions */=20
table.MsoNormalTable

	{mso-style-name:&#26222;&#36890;&#34920;&#26684;;
	mso-tstyle-rowband-size:0;
	mso-tstyle-colband-size:0;
	mso-style-noshow:yes;
	mso-style-parent:"";
	mso-padding-alt:0cm 5.4pt 0cm 5.4pt;
	mso-para-margin:0cm;
	mso-para-margin-bottom:.0001pt;
	mso-pagination:widow-orphan;
	font-size:10.0pt;
	font-family:"Times New Roman";}

</style>
<![endif]--></HEAD>
<BODY lang=3DZH-CN style=3D"TEXT-JUSTIFY-TRIM: punctuation; =
tab-interval: 21.0pt"=20
vLink=3Dpurple link=3Dblue>
<DIV>connect as owner of procedure to sqlplus</DIV>
<DIV>select=20
* from user_errors where name =3D 'XXXXX'</DIV>
<DIV>(XXXXX=20
=3D procedure name)</DIV>
<BLOCKQUOTE dir=3Dltr style=3D"MARGIN-RIGHT: 0px">
 <DIV class=3DOutlookMessageHeader dir=3Dltr align=3Dleft>-----Original Message----- From: liujd=20 [mailto:liujd_at_cti.ac.cn] Sent: Thursday, March 20, 2003 = 12:34=20
 AM To: Multiple recipients of list = ORACLE-L Subject:=20

  <BR><BR></FONT></DIV>
  <DIV class=3DSection1>
  <P class=3DMsoNormal style=3D"TEXT-ALIGN: left; =

mso-layout-grid-align: none"=20
 align=3Dleft>My oracle=20
 using version is 8.0.0.5.<o:p></o:p> Now=20
 , = I'm=20
 programming proc .<o:p></o:p> When I <SPAN=20
 class=3DSpellE>precompile them<SPAN=20 style=3D"mso-spacerun: yes">  and fail. But I = can't see what=20
 happened .and where the errors are.<o:p></o:p> So I look=20
 carefully  =

for errors in large file.<o:p></o:p> Is there=20
 some way to show where the error is .and what the error is=20
 .<o:p></o:p>
 Can you give=20
 me your hand =
.<o:p></o:p>
 Thanks in=20
 advance!<o:p></o:p>
 <o:p> </o:p></DIV></BLOCKQUOTE></BODY></H=

TML>

 
 

Privileged/Confidential information =
may be contained in this message. The information contained in this = message is intended only for the use of the recipient(s) named above = and their co-workers who are working on the same matter.
 

The recipient of this information =
is prohibited from disclosing the information to any other party unless = this disclosure has been authorized in advance.
 

If you are not intended recipient =
of this message or any agent responsible for delivery of the message to =

the intended recipient, you are hereby notified that any disclosure, =
copying, distribution or action taken in reliance on the contents of =
this message is strictly prohibited.  You should immediately destroy =

this message and kindly notify the sender by reply = E-Mail.
 

Please advise immediately if you or =
your employer does not consent to Internet E-Mail for messages of this = Received on Thu Mar 20 2003 - 04:14:02 CST