Re: Newbie package/procedure syntax help

From: Valery Yourinsky <vsu_at_bill.mts.ru>
Date: Fri, 26 Jan 2001 10:16:00 +0300
Message-ID: <3A712430.2418944E@bill.mts.ru>

james_one_at_my-deja.com wrote:
>
> Can anyone please tell me why this doesn't work? The package creates
> fine, but the body has 'complilation errors'. Client is 8.1.6. DB is
> oracle 7.3.
> Thanks.
>
> CREATE OR REPLACE
> PACKAGE PACK1 IS
> TYPE CURSOR_TYPE AS REF CURSOR;
> PROCEDURE GET_USERS (USER_NAME IN CHAR,
> O_RESULT_SET OUT CURSOR_TYPE);
> END;
> /
> CREATE OR REPLACE
> PACKAGE BODY PACK1 AS
> PROCEDURE GET_USERS (USER_NAME IN CHAR,
> O_RESULT_SET OUT CURSOR_TYPE)
> AS
> BEGIN
> OPEN O_RESULT_SET FOR
> SELECT FULLNAME, PASSWORD
> FROM USER_INFO
> WHERE USERNAME = USER_NAME;
> END;
> END;
> /

  TYPE CURSOR_TYPE IS REF CURSOR;

                    ^

  ... IS REF CURSOR;
  Not AS!

Valery Yourinsky

-- 
Oracle8 Certified DBA
Moscow, Russia

Received on Fri Jan 26 2001 - 01:16:00 CST