Hi! I've a ref cursor already opened by an external procedure. I need to fetch it into an object table like this
CREATE OR REPLACE TYPE TAB_CUSTOM AS TABLE OF REC_CUSTOM;
where
CREATE OR REPLACE TYPE REC_CUSTOM AS OBJECT
(
my_id NUMBER(6)
.......
,CONSTRUCTOR FUNCTION REC_CUSTOM RETURN SELF AS RESULT
)
NOT FINAL;
/
has the exact columns, types and size of the opened ref cursor.
How can this be accomplished?