Hi Yes, I rectify it.
regards, Sonal On 1/21/11, Avinash Naidu <avisna...@gmail.com> wrote: > 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 -- 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
