PL/SQL (MOSC)

MOSC Banner

Error with RefCursor

edited Jun 23, 2013 11:18PM in PL/SQL (MOSC) 3 commentsAnswered
Hello All,I have a procedure

PROCEDURE get_tran_detail (
i_user_id IN NUMBER := 0,
i_portfolio_id_list IN NUM_ARRAY,
i_from_dt IN transaction.trade_dt%TYPE,
i_to_dt IN transaction.trade_dt%TYPE,
i_include_suppress_txn IN NUMBER,
o_transactions OUT TXN_SUMMARY_INFO_ARRAY_test, ----output
i_debugmode IN NUMBER := 0
);

How do I get the o_transactions to be inserted into a GTT?


This is what I have so far

CREATE OR REPLACE PROCEDURE get_control_ref_cursor( p_ref_cursor OUT SYS_REFCURSOR )
AS
l_base_proc_ref_cursor SYS_REFCURSOR;
l_result_rec MI_GET_TXN_GTT%rowtype;

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