Error with RefCursor
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
);
This is what I have so far
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;
0