The way SQL*Plus works: if you run a script with "set echo off", but the script has a multi-line comment beginning with /* and ending with */, every comment line after the first one will show in the SQL*Plus output with DOC> in the line prefix instead of SQL>.
The show errors will not show errors if the package you are creating belongs to someone else. Look for an uncommented "create package body" in your script, then look in dba_errors for that package body. > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of > Mercadante, Thomas F > > Why do you have a */ as the last line? And why is the script > prefaced with > DOC> ? > > It looks like you have either an unbalanced comment indicator > (*/) or the > whole thing is a mess. Further, the error indicates that you > have errors in > the package body but you are showing us the package. > > If you could post the whole thing (package and package body) > we could help > you better. > > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of > Oracle DBA > > Could you please help to see the errors in the package > compilation? Please see below > > SQL> @xyz_pkg.sql > DOC>CREATE OR REPLACE PACKAGE "XYZ_PKG" > DOC>AS > DOC>-- > DOC>PROCEDURE UPDATE_TEST(COL1 IN DROP_ME.C1%TYPE); > DOC>END XYZ_PKG; > DOC> > DOC>*/ > > Warning: Package Body created with compilation errors. > > SQL> show err > No errors. > SQL> -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jacques Kilchoer INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
