Error [PLS-00103: Encountered the symbol "CREATE"] using PACKAGE
717252Aug 13 2009 — edited Sep 15 2009Hi guys!
When I compile this Package, i get this Error:
PLS-00103: Encountered the symbol "CREATE"
How can I solve this problem?
The code compiled is bellow:
CREATE OR REPLACE
PACKAGE CAMPO_PACK AS
TYPE T_CURSOR IS REF CURSOR;
PROCEDURE DeleteCode(pCod NUMBER);
END CAMPO_PACK;
---- body ----
CREATE OR REPLACE PACKAGE BODY CAMPO_PACK AS
PROCEDURE DeleteCode(pCod NUMBER) AS
BEGIN
DELETE FROM campo
WHERE cod = pcod;
END DeleteCode;
END CAMPO_PACK;
Thanks for help,
Anderson
Edited by: user8723300 on 13/08/2009 17:03
Edited by: user8723300 on 13/08/2009 17:04