>
> 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_
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
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 e
It seams that u didn't create any body to the package
-Mensagem original-
De: Oracle DBA [mailto:[EMAIL PROTECTED]
Enviada: sexta-feira, 19 de Setembro de 2003 15:35
Para: Multiple recipients of list ORACLE-L
Assunto: Package Body created with compilation errors-
Hi List,
Coul
? 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 erro
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&
> @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>
___
Title: RE: Package Body created with compilation errors-
the code you provided and the oracle error message do not rhyme ... you are showing us the wrong code.
Raj
-Original Message-
From: Oracle DBA [mailto:[EMAIL PROTECTED]]
Sent: Friday, September 19, 2003 10:35 AM
To
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: Pac