Newbie package/procedure syntax help

From: <james_one_at_my-deja.com>
Date: Thu, 25 Jan 2001 17:50:32 GMT
Message-ID: <94pp13$pit$1@nnrp1.deja.com>

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;
/

Sent via Deja.com
http://www.deja.com/ Received on Thu Jan 25 2001 - 11:50:32 CST