Helpful Information
 
 
Category: Oracle Development
Ref Cursor

Hi, I have written this code,,

create or replace package kit_admin
as
TYPE PackRec IS RECORD (pack_cd VARCHAR2(5));
TYPE crsr IS REF CURSOR RETURN PackRec;
procedure selectPackages(V_crsr OUT crsr);
end kit_admin;

This package gets created nicely but the body is not getting created,,,, Body is as follows.

create or replace package body kit_admin
is
TYPE crsr IS REF CURSOR RETURN PackRec;
procedure selectPackages(V_crsr OUT crsr)
is
V_crsr is
select package_cd from kit_packages;

end selectPackages;
end kit_admin;

the error while creating this body is as follows:

Errors for PACKAGE BODY KIT_ADMIN:

LINE/COL ERROR
-------- -----------------------------------------------------------------
6/10 PLS-00103: Encountered the symbol "SELECT" when expecting one of
the following:
constant exception <an identifier>
<a double-quoted delimited-identifier> table LONG_ double ref
char time timestamp interval date binary national character
nchar

9/2 PLS-00103: Encountered the symbol "END" when expecting one of the
following:
begin function package pragma procedure subtype type use
<an identifier> <a double-quoted delimited-identifier> cursor

LINE/COL ERROR
-------- -----------------------------------------------------------------
form current

Please suggest,,

Thanks

What exactly are you trying to do here?

It seems like you're approaching your task with more complicated pl/sql than is necessary...

As martysb asked, what are you trying to accomplish here?










privacy (GDPR)