REP-0065 REP-0200 when running ref cursor report
I have created an oracle report that returns data in a ref cursor.I am running the report from Report Builder 11.1.1.4.0
When I run the ref_cursor from pl/sql developer it returns data no problem but from the report I get the error
REP-0065: A virtual memory system error occurred.
REP-0200: Enough memory cannot be allocated.
The types I am using is defined as
CREATE OR REPLACE TYPE test_text_type AS TABLE OF VARCHAR2(4000)
/
CREATE OR REPLACE TYPE test_refcursor_type AS OBJECT
(TEST_NUMBER NUMBER(9),
TEST_CHAR VARCHAR2(120),
TEST_SUM NUMBER (7,3),
TEST_TEXT test_text_type
)
/
CREATE OR REPLACE TYPE test_refcursor_tab_type IS TABLE OF test_refcursor_type
When I run the ref_cursor from pl/sql developer it returns data no problem but from the report I get the error
REP-0065: A virtual memory system error occurred.
REP-0200: Enough memory cannot be allocated.
The types I am using is defined as
CREATE OR REPLACE TYPE test_text_type AS TABLE OF VARCHAR2(4000)
/
CREATE OR REPLACE TYPE test_refcursor_type AS OBJECT
(TEST_NUMBER NUMBER(9),
TEST_CHAR VARCHAR2(120),
TEST_SUM NUMBER (7,3),
TEST_TEXT test_text_type
)
/
CREATE OR REPLACE TYPE test_refcursor_tab_type IS TABLE OF test_refcursor_type
0