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

Home -> Community -> Mailing Lists -> Oracle-L -> how to see errors when precompiling proc program

how to see errors when precompiling proc program

From: Áõ¼Ì¶« <liujd_at_cti.ac.cn>
Date: Thu, 20 Mar 2003 14:49:59 +0800
Message-Id: <24715.322474@fatcity.com> 





This is a multi-part message in MIME format.



--=====002_Dragon236182704230_=====


Content-Type: text/plain;


      charset="GB2312"


Content-Transfer-Encoding: quoted-printable



My oracle using version is 8.0.0.5.


Now , I'm programming proc .


When I precompile them  and fail. But I can=A1=AFt 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!



--=====002_Dragon236182704230_=====


Content-Type: text/html;


      charset="GB2312"


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=3Dgb2312">


<META content=3D"MSHTML 6.00.2600.0" name=3DGENERATOR></HEAD>

<BODY bgColor=3D#eaeaea>

<P class=3DMsoNormal style=3D"TEXT-ALIGN: left;=

 mso-layout-grid-align: none" 


align=3Dleft><FONT face=3DArial size=3D1><SPAN lang=3DEN-US 
style=3D"FONT-SIZE: 9pt; FONT-FAMILY: Arial; mso-font-kerning:=
 0pt">My oracle 


using version is 8.0.0.5.<?xml:namespace prefix =3D o ns =3D 
"urn:schemas-microsoft-com:office:office"=
 /><o:p></o:p></SPAN></FONT></P>


<P class=3DMsoNormal style=3D"TEXT-ALIGN: left;=

 mso-layout-grid-align: none" 

align=3Dleft><SPAN class=3DGramE><FONT face=3DArial size=3D1><SPAN=
 lang=3DEN-US 
style=3D"FONT-SIZE: 9pt; FONT-FAMILY: Arial; mso-font-kerning:=


 0pt">Now 


,</SPAN></FONT></SPAN><FONT face=3DArial size=3D1><SPAN lang=3DEN-US 
style=3D"FONT-SIZE: 9pt; FONT-FAMILY: Arial; mso-font-kerning:=
 0pt"> I'm 


programming proc .<o:p></o:p></SPAN></FONT></P>


<P class=3DMsoNormal style=3D"TEXT-ALIGN: left;=

 mso-layout-grid-align: none" 


align=3Dleft><FONT face=3DArial size=3D1><SPAN lang=3DEN-US 
style=3D"FONT-SIZE: 9pt; FONT-FAMILY: Arial; mso-font-kerning:=
 0pt">When I <SPAN 


class=3DSpellE>precompile</SPAN> <SPAN class=3DGramE>them<SPAN 
style=3D"mso-spacerun: yes">&nbsp; </SPAN>and</SPAN> fail. But I=
 can=A1=AFt see what 


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" 


align=3Dleft><FONT face=3DArial size=3D1><SPAN lang=3DEN-US 
style=3D"FONT-SIZE: 9pt; FONT-FAMILY: Arial; mso-font-kerning:=
 0pt">So I look 


<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" 


align=3Dleft><FONT face=3DArial size=3D1><SPAN lang=3DEN-US 
style=3D"FONT-SIZE: 9pt; FONT-FAMILY: Arial; mso-font-kerning:=
 0pt">Is there some 


way to show where the error is .and what the error <SPAN=
 class=3DGramE>is 


.</SPAN><o:p></o:p></SPAN></FONT></P>


<P class=3DMsoNormal style=3D"TEXT-ALIGN: left;=

 mso-layout-grid-align: none" 


align=3Dleft><FONT face=3DArial size=3D1><SPAN lang=3DEN-US 
style=3D"FONT-SIZE: 9pt; FONT-FAMILY: Arial; mso-font-kerning:=
 0pt">Can you give 


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" 


align=3Dleft><FONT face=3DArial size=3D1><SPAN lang=3DEN-US 
style=3D"FONT-SIZE: 9pt; FONT-FAMILY: Arial; mso-font-kerning:=
 0pt">Thanks in 


advance!<o:p></o:p></SPAN></FONT></P></BODY></HTML>
Received on Thu Mar 20 2003 - 00:49:59 CST












Original text of this message













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