RE: Package Body created with compilation errors-

[raju pa]

Just FYI : Quotes do not mean anything here. Quotes are generally used to create lowercase objects. Without quotes everything is converted to uppercase.

"Virk, Istifad" <[EMAIL PROTECTED]> wrote:

Try compiling without the quotes around the package name:

CREATE OR REPLACE PACKAGE XYZ_PKG


-----Original Message-----
Sent: 19 September 2003 15:35
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: [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).

This e-mail and any attachment is for authorised use by the intended recipient(s) only. It may contain proprietary material, confidential information and/or be subject to legal privilege. It should not be copied, disclosed to, retained or used by, any other party. If you are not an intended recipient then please promptly delete this e-mail and any attachment and all co! pies and inform the sender. Thank you.

LogicaCMG global sponsors, Gartner Symposium, Cannes, 4th -7th November 2003

http://symposium.gartner.com/story.php.id.3323.s.5.html

Please note that LogicaCMG does not have control over content from,or availability of, this website
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Virk, Istifad
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).

---

Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software