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: how to see errors when precompiling proc program

RE: how to see errors when precompiling proc program

From: Virk, Istifad <Istifad.Virk_at_logicacmg.com>
Date: Thu, 20 Mar 2003 11:07:30 -0000
Message-Id: <24726.322523@fatcity.com>


In your script file, put:
SHOW ERRORS
after the procedure text.

-----Original Message-----
From: liujd_at_cti.ac.cn [mailto:liujd_at_cti.ac.cn] Sent: 20 March 2003 06:49
To: Multiple recipients of list ORACLE-L Subject: how to see errors when precompiling proc program

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>

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

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: =?GB2312?Q?=C1=F5=BC=CC=B6=AB?=
  INET: liujd_at_cti.ac.cn

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

-------

This e-mail and any attachment is for authorised use by the intended recipient(s) only.  It may contain proprietary material, confidential information and/or be subject to legal privilege.  It should not be copied, disclosed to, retained or used by, any other party.  If you are not an intended recipient then please promptly delete this e-mail and any attachment and all copies and inform the sender.  Thank you.
Received on Thu Mar 20 2003 - 05:07:30 CST

Original text of this message

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