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

Home -> Community -> Usenet -> c.d.o.server -> Oracle packages

Oracle packages

From: Olivier Deborne <odeborne_at_hotmail.com>
Date: 21 Nov 2002 06:57:48 -0800
Message-ID: <b0c018e3.0211210657.6c02b2e5@posting.google.com>


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
BEGIN          OPEN crCURSOR FOR          
	 SELECT level,
		  PART_NO,

(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 =
RECIPE_STRUCTURE.PART_NO; END RECIPE_STRUCTURE_RPT; /

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

Original text of this message

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