Message-Id: <24726.322523@fatcity.com> From: "Virk, Istifad" Date: Thu, 20 Mar 2003 11:07:30 -0000 Subject: RE: how to see errors when precompiling proc program In your script file, put: SHOW ERRORS after the procedure text. -----Original Message----- From: liujd@cti.ac.cn [mailto:liujd@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

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_=====-- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?GB2312?Q?=C1=F5=BC=CC=B6=AB?= INET: liujd@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@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.