Re: Newbie package/procedure syntax help

I'd be happy to include more error details, but 'compiliation errors' is all that SQL Plus reports.
Is there any better tool that will point out your syntax problems?

In article <94pt51$ek7ts$3_at_ID-62141.news.dfncis.de>,   "Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote:
> 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/
>
>

Sent via Deja.com
http://www.deja.com/ Received on Thu Jan 25 2001 - 14:12:58 CST