RE: Package Body created with compilation errors-

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: ml-errors_at_fatcity.com [mailto:ml-errors_at_fatcity.com]On 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: ml-errors_at_fatcity.com [mailto:ml-errors_at_fatcity.com]On 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: Jacques.Kilchoer_at_quest.com

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).