RE: Package Body created with compilation errors-

From: Mercadante, Thomas F <NDATFM_at_labor.state.ny.us>
Date: Fri, 19 Sep 2003 07:19:39 -0800
Message-ID: <F001.005D082A.20030919071939@fatcity.com>

Sami,

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.

Tom Mercadante
Oracle Certified Professional

-----Original Message-----
Sent: Friday, September 19, 2003 10:35 AM To: Multiple recipients of list ORACLE-L

Hi List,

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>

---

Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Oracle DBA
  INET: sami_resume_at_yahoo.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).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Mercadante, Thomas F
  INET: NDATFM_at_labor.state.ny.us

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). Received on Fri Sep 19 2003 - 10:19:39 CDT