Hi All,
I want to create a package, and declare a ref_cursor type in its
declaration part and it gives me an error:
Package that I written:
create or replace package pack_1 as
type s is ref_cursor return dept%rowtype;
procedure p1(a in s);
end;
and package specification has occurred an error:
SQL> show errors;
Errors for PACKAGE PACK_1:
LINE/COL ERROR
--------
-----------------------------------------------------------------
2/11 PLS-00103: Encountered the symbol "REF_CURSOR" when expecting
one
of the following:
( array limited new private range record VARRAY_ char_base
number_base decimal date_base clob_base blob_base bfile_base
table ref object fixed varying opaque
2/41 PLS-00103: Encountered the symbol ";" when expecting one of
the
following:
. ( , * @ % & - + / at mod rem <an identifier>
<a double-quoted delimited-identifier> <an exponent (**)> as
into || bulk
As I want to refer the ref_cursor type in various procedure and only
include in the package specification and dont want to use the
sys_refcursor.
Regards,
Sonia
--
You received this message because you are subscribed to the Google
Groups "Oracle PL/SQL" group.
To post to this group, send email to Oracle-PLSQL@googlegroups.com
To unsubscribe from this group, send email to
oracle-plsql-unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/Oracle-PLSQL?hl=en
