Home -> Usenet -> comp.databases.oracle -> Re: Compile errors in stored procedures

Re: Compile errors in stored procedures

From: Robert Sechrest Ext 21856 <sechrest_at_zuni.litc.lockheed.com>
Date: Fri, 7 Jan 1994 17:56:12 GMT
Message-ID: <CJ9ttp.B9E_at_butch.lmsc.lockheed.com> 







Todd Richmond (todd_at_storm01.aadt.com) wrote:


: << Posting for a co-worker.  Reply to this group or chuck_at_aadt.com >>


 


: How do I get more detailed information from Oracle when compiling a stored procedure?  Currently any error in the SQL causes SQL*Plus to spit out:


 


: "Procedure created with compilation errors"


 


: Any help?


: --




Try selecting from the table USER_ERRORS.  It should tell you the error
message text, along with the offending line number within the procedure.
It might help to SET ECHO ON and SET SPOOL in SQL*Plus prior to compiling
so that you have the line numbers that are assigned to your procedure
code as it's compiled.



    
  
  •   Robert Sechrest, LMSC



Received on Fri Jan 07 1994 - 18:56:12 CET












Original text of this message