Thanks guys. The missing "/" was the problem.
Daniel Morgan <damorgan_at_x.washington.edu> wrote in message news:<1096937565.749713_at_yasure>...
> pcmodeler wrote:
>
> > I'm new to Oracle. Trying to write my first package and I keep
> > getting an error stating that it doesn't like the Create statement on
> > line 6. Even removing it creates an error. I don't fully understand
> > cursors yet, so that probably has somethign to do with it, but
> > according to my documentation, it should be correct.
> >
> > CREATE OR REPLACE PACKAGE PG_TEST AS
> > TYPE cdcur IS REF CURSOR;
> > PROCEDURE SP_TEST
> > (CRSE_CD IN OUT cdcur);
> > END PG_TEST;
> > CREATE OR REPLACE PACKAGE BODY PG_TEST
> > AS
> > PROCEDURE SP_TEST
> > (CRSE_CD IN OUT cdcur)
> > IS
> > BEGIN
> > OPEN CRSE_CD FOR
> > SELECT
> > CRSE_TTL, LOCAL_CRSE_CD
> > FROM
> > CRSE
> > WHERE
> > CRSE_TTL LIKE '%Learn%';
> >
> > END SP_TEST;
> >
> > END PG_TEST;
> > /
>
> You can find working examples at http://www.psoug.org
> click on Morgan's Library
> click on REF CURSOR.
Received on Tue Oct 05 2004 - 09:54:12 CDT
