The returned ref cursor is not supported

Question

I am trying to create a chart in the database management panel reporting software (Logi Info). I have a PL SQL package that returns a ref cursor with multiple values, but Logi Info doesn't seem to support this and gives me an error ORA-00904: "DASHBOARD_PACKAGE"."GETSUMMARYDATA": invalid identifier. I think this is either not supported, or that my doubt is wrong. This is my request:

select dashboard_package.getSummaryData (1, sysdate) from double

Is this a function call that returns multiple values? if so, is there a solution to this problem (return type is not supported)?

Answer 1

If you are using SQL * Plus, you need to use special syntax to access REUR CURSORS.

SQL * Plus:
http://download.oracle.com/docs/cd/B19306_01/server.102/b14357/ch5.htm#sthref1127

- :

VARIABLE cv REFCURSOR
EXECUTE dashboard_package.getSummaryData(1, sysdate, :cv)
print cv

, :cv .
...

Edit
( APC): ref, , :
http://download.oracle.com/docs/cd/B19306_01/server.102/b14357/ch5.htm#sthref1128

VARIABLE cv REFCURSOR
execute :cv := dashboard_package.getSummaryData(1, sysdate);
print cv

Answer 2

. GETSUMMARYDATA() , , - . SQL, .

, . , , .