RE:

[Kurth, Michael J.]

connect as owner of procedure to sqlplus select * from user_errors where name = 'XXXXX' (XXXXX = procedure name) -----Original Message----- From: liujd [mailto:[EMAIL PROTECTED] 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.