Oracle Reports (MOSC)

MOSC Banner

REP-0065 REP-0200 when running ref cursor report

edited Sep 11, 2018 5:00AM in Oracle Reports (MOSC) 13 commentsAnswered
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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center