it is "REF CURSOR" and not ref_cursor On Thu, Jan 20, 2011 at 9:23 PM, Sonal <sonu.oa...@gmail.com> wrote:
> 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 -- 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
