RE: Package Body created with compilation errors-

2003-09-19 Thread Jacques Kilchoer
> > 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_

RE: Package Body created with compilation errors-

2003-09-19 Thread 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

RE: Package Body created with compilation errors-

2003-09-19 Thread Mercadante, Thomas F
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

RE: Package Body created with compilation errors-

2003-09-19 Thread Paulo Gomes
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

RE: Package Body created with compilation errors-

2003-09-19 Thread Igor Neyman
? 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

Re: Package Body created with compilation errors-

2003-09-19 Thread Tanel Poder
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&

RE: Package Body created with compilation errors-

2003-09-19 Thread Virk, Istifad
> @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> ___

RE: Package Body created with compilation errors-

2003-09-19 Thread Jamadagni, Rajendra
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

Package Body created with compilation errors-

2003-09-19 Thread Oracle DBA
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