Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Package Body created with compilation errors-

RE: Package Body created with compilation errors-

From: raju pa <raju_pa_24_at_yahoo.com>
Date: Fri, 19 Sep 2003 07:44:43 -0800
Message-ID: <F001.005D082E.20030919074443@fatcity.com>


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" <Istifad.Virk_at_logicacmg.com> 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: 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).

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 copies 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: Istifad.Virk_at_logicacmg.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).

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

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

Author: raju pa
  INET: raju_pa_24_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). Received on Fri Sep 19 2003 - 10:44:43 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US