Re: Newbie package/procedure syntax help

In article <94q1c0$21r$1_at_nnrp1.deja.com>,   james_one_at_my-deja.com wrote:
> 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/
>

Yes. Type 'show errors' after the compilation reports errors were encountered. The errors encountered and the nature of the errors will be displayed.

--
David Fitzjarrell
Oracle Certified DBA


Sent via Deja.com
http://www.deja.com/