Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE:

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>
 <o:OfficeDocumentSettings>
  <o:DoNotRelyOnCSS/>
 </o:OfficeDocumentSettings>
</xml><![endif]--><!--[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 =

&#30917;</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: &#23435;
}
@font-face {

        font-family: @&#23435;&#20307;;
}
@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: &#23435; 20307:=20 }
LI.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: &#23435; 20307:=20 }
DIV.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: &#23435; 20307:=20 }
A:link {

        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: &#23435; 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]--><!--[if gte mso 9]><xml>

 <o:shapedefaults v:ext=3D"edit" spidmax=3D"1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
 <o:shapelayout v:ext=3D"edit">
  <o:idmap v:ext=3D"edit" data=3D"1" />
 </o:shapelayout></xml><![endif]--></HEAD>
<BODY lang=3DZH-CN style=3D"TEXT-JUSTIFY-TRIM: punctuation; =
tab-interval: 21.0pt"=20
vLink=3Dpurple link=3Dblue>
<DIV><SPAN class=3D736381110-20032003><FONT face=3DArial =
color=3D#0000ff=20
size=3D2>connect as owner of procedure to sqlplus</FONT></SPAN></DIV>
<DIV><SPAN class=3D736381110-20032003><FONT face=3DArial =
color=3D#0000ff size=3D2>select=20
* from user_errors where name =3D 'XXXXX'</FONT></SPAN></DIV>
<DIV><SPAN class=3D736381110-20032003><FONT face=3DArial =
color=3D#0000ff size=3D2>(XXXXX=20
=3D procedure name)</FONT></SPAN></DIV>
<BLOCKQUOTE dir=3Dltr style=3D"MARGIN-RIGHT: 0px">
  <DIV class=3DOutlookMessageHeader dir=3Dltr align=3Dleft><FONT = face=3DTahoma=20
  size=3D2>-----Original Message-----<BR><B>From:</B> liujd=20   [mailto:liujd_at_cti.ac.cn]<BR><B>Sent:</B> Thursday, March 20, 2003 = 12:34=20
  AM<BR><B>To:</B> Multiple recipients of list = ORACLE-L<BR><B>Subject:</B>=20
  <BR><BR></FONT></DIV>
  <DIV class=3DSection1>
  <P class=3DMsoNormal style=3D"TEXT-ALIGN: left; =
mso-layout-grid-align: none"=20
  align=3Dleft><FONT face=3DArial size=3D1><SPAN lang=3DEN-US=20   style=3D"FONT-SIZE: 9pt; FONT-FAMILY: Arial; mso-font-kerning: = 0pt">My oracle=20
  using version is 8.0.0.5.<o:p></o:p></SPAN></FONT></P>   <P class=3DMsoNormal style=3D"TEXT-ALIGN: left; = mso-layout-grid-align: none"=20
  align=3Dleft><SPAN class=3DGramE><FONT face=3DArial size=3D1><SPAN = lang=3DEN-US=20
  style=3D"FONT-SIZE: 9pt; FONT-FAMILY: Arial; mso-font-kerning: = 0pt">Now=20
  ,</SPAN></FONT></SPAN><FONT face=3DArial size=3D1><SPAN lang=3DEN-US=20   style=3D"FONT-SIZE: 9pt; FONT-FAMILY: Arial; mso-font-kerning: 0pt"> = I'm=20
  programming proc .<o:p></o:p></SPAN></FONT></P>   <P class=3DMsoNormal style=3D"TEXT-ALIGN: left; = mso-layout-grid-align: none"=20
  align=3Dleft><FONT face=3DArial size=3D1><SPAN lang=3DEN-US=20   style=3D"FONT-SIZE: 9pt; FONT-FAMILY: Arial; mso-font-kerning: = 0pt">When I <SPAN=20
  class=3DSpellE>precompile</SPAN> <SPAN class=3DGramE>them<SPAN=20   style=3D"mso-spacerun: yes">&nbsp; </SPAN>and</SPAN> fail. But I = can't see what=20
  happened .and where the errors are.<o:p></o:p></SPAN></FONT></P>   <P class=3DMsoNormal style=3D"TEXT-ALIGN: left; = mso-layout-grid-align: none"=20
  align=3Dleft><FONT face=3DArial size=3D1><SPAN lang=3DEN-US=20   style=3D"FONT-SIZE: 9pt; FONT-FAMILY: Arial; mso-font-kerning: = 0pt">So I look=20
  <SPAN class=3DGramE>carefully<SPAN style=3D"mso-spacerun: yes">&nbsp; =

  </SPAN>for</SPAN> errors in large file.<o:p></o:p></SPAN></FONT></P>   <P class=3DMsoNormal style=3D"TEXT-ALIGN: left; = mso-layout-grid-align: none"=20
  align=3Dleft><FONT face=3DArial size=3D1><SPAN lang=3DEN-US=20   style=3D"FONT-SIZE: 9pt; FONT-FAMILY: Arial; mso-font-kerning: = 0pt">Is there=20
  some way to show where the error is .and what the error <SPAN = class=3DGramE>is=20
  .</SPAN><o:p></o:p></SPAN></FONT></P>
  <P class=3DMsoNormal style=3D"TEXT-ALIGN: left; = mso-layout-grid-align: none"=20
  align=3Dleft><FONT face=3DArial size=3D1><SPAN lang=3DEN-US=20   style=3D"FONT-SIZE: 9pt; FONT-FAMILY: Arial; mso-font-kerning: = 0pt">Can you give=20
  me your <SPAN class=3DGramE>hand =
.</SPAN><o:p></o:p></SPAN></FONT></P>
  <P class=3DMsoNormal style=3D"TEXT-ALIGN: left; = mso-layout-grid-align: none"=20
  align=3Dleft><FONT face=3DArial size=3D1><SPAN lang=3DEN-US=20   style=3D"FONT-SIZE: 9pt; FONT-FAMILY: Arial; mso-font-kerning: = 0pt">Thanks in=20
  advance!<o:p></o:p></SPAN></FONT></P>
  <P class=3DMsoNormal><FONT face=3DArial size=3D1><SPAN lang=3DEN-US=20   style=3D"FONT-SIZE: 9pt; FONT-FAMILY: Arial; mso-bidi-font-size: = 10.0pt"><o:p>&nbsp;</o:p></SPAN></FONT></P></DIV></BLOCKQUOTE></BODY></H=

TML>

<BR>
<BR>

<P><B><FONT SIZE=3D2 FACE=3D"Arial">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.</FONT></B></P>
<BR>

<P><B><FONT SIZE=3D2 FACE=3D"Arial">The recipient of this information =
is prohibited from disclosing the information to any other party unless = this disclosure has been authorized in advance.</FONT></B></P>
<BR>

<P><B><FONT SIZE=3D2 FACE=3D"Arial">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.</FONT></B></P>
<BR>

<P><B><FONT SIZE=3D2 FACE=3D"Arial">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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US