error while executing function [message #359052] |
Thu, 13 November 2008 08:55  |
pointers
Messages: 451 Registered: May 2008
|
Senior Member |
|
|
Hi,
create or replace package pkg_refcursor
as
type rc is ref cursor;
end;
SQL>
1 create or replace function rcreturn return pkg_refcursor.rc
2 as
3 rf pkg_refcursor.rc;
4 begin
5 open rf for select ad from test_mine;
6 return rf;
7* end rcreturn;
SQL> /
Function created.
SQL> set serveroutput on;
SQL> select rcreturn from dual;
select rcreturn from dual
*
ERROR at line 1:
ORA-00902: invalid datatype
I am getting the above error. Please suggest where I am doing wrong.
The table description is as follows..
SQL> desc mine_test;
Name Null? Type
----------------------------------------- -------- ----------------------------
A NUMBER
B VARCHAR2(10)
SQL> desc test_mine;
Name Null? Type
----------------------------------------- -------- ----------------------------
AD NUMBER
SQL> select * from test_mine;
AD
----------
1
2
3
4
5
6
7
8
9
9 rows selected.
Regards,
Pointers.
|
|
|
|
|
|