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>
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>
<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
, I'm
programming proc .<o:p></o:p>
When I precompile them  and fail. But I= can=A1=AFt see what
happened .and where the errors are.<o:p></o:p>
So I look
carefully =

for errors in large=

file.<o:p></o:p>
Is there some
way to show where the error is .and what the error <SPAN= class=3DGramE>is
.<o:p></o:p>
Can you give
me your hand=
.<o:p></o:p>
Thanks in
advance!<o:p></o: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