Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Trying to write first package
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;
/
Received on Mon Oct 04 2004 - 12:28:34 CDT
![]() |
![]() |