Re: Trying to write first package

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.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)