Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Oracle packages
Hello,
I just created the following package and procedure:
CREATE OR REPLACE PACKAGE RECIPE_STRUCTURE_PKG
AS TYPE crType IS REF CURSOR;
END RECIPE_STRUCTURE_PKG;
/
CREATE OR REPLACE PROCEDURE RECIPE_STRUCTURE_RPT (
crCursor IN OUT RECIPE_STRUCTURE_PKG.crType, pPART_NO IN RECIPE_STRUCTURE.PART_NO%TYPE)AS
SELECT level, PART_NO,RECIPE_STRUCTURE.PART_NO; END RECIPE_STRUCTURE_RPT; /
(SELECT DESCRIPTION FROM INVENTORY_PART WHERE PART_NO =
RECIPE_STRUCTURE.PART_NO) PART_DESCRIPTION, LINE_SEQUENCE, COMPONENT_PART,
(SELECT DESCRIPTION FROM INVENTORY_PART WHERE PART_NO =
RECIPE_STRUCTURE.COMPONENT_PART) COMPONENT_DESCRIPTION, QTY_PER_ASSEMBLY,
(SELECT LEAD_TIME_CODE FROM INVENTORY_PART WHERE PART_NO =
RECIPE_STRUCTURE.COMPONENT_PART) LEAD_TIME_CODE FROM RECIPE_STRUCTURE START WITH RECIPE_STRUCTURE.PART_NO = pPART_NO CONNECT BY PRIOR RECIPE_STRUCTURE.COMPONENT_PART =
It compiles just fine on my server (ora 90) but on another server which runs Oracle 8.0.1.7 I get the following error:
PLS-00103: Encountered the symbol "SELECT" when expecting one of the following:
( - + mod not null others <an identifier> <a double-quoted delimited-identifier> <a bind variable> avg count c
Any idea someone?
Thanks for your help.
Olivier Deborne. Received on Thu Nov 21 2002 - 08:57:48 CST