Re: Newbie package/procedure syntax help

How do you expect help if you don't include those 'compilation errors' in your post.
Also you are running a higher version client against a lower version database, which is, apart from the fact the database version has been desupported, *not* guaranteed to work, and most likely will not work at all.

Regards,

Sybrand Bakker, Oracle DBA

<james_one_at_my-deja.com> wrote in message news:94pp13$pit$1_at_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 - 12:16:48 CST