Invoking a proecdure having REFCURSOR as IN OUT parameter
Hi there,
V_X4 ar_adjustments_all.amount%TYPE,
V_X3 ar_adjustments_all.amount%TYPE,
v_X2 ar_adjustments_all.attribute2%TYPE,
v_x1 ar_adjustments_all.attribute3%TYPE,
V_X5 ar_payment_schedules_all.terms_sequence_number%TYPE);
TYPE cur_type IS REF CURSOR RETURN get_abc_data;Package BODY is like :PROCEDURE PR_XYX_DAT(xyz_id IN NUMBER
What is the best way to invoke a procedure(part of package) from an ANONYMOUS PL/SQL block ?
The procedure has REF CURSOR as INOUT parameter.
More Details:
Package spec is like:
TYPE get_abc_data is record(V_X4 ar_adjustments_all.amount%TYPE,
V_X3 ar_adjustments_all.amount%TYPE,
v_X2 ar_adjustments_all.attribute2%TYPE,
v_x1 ar_adjustments_all.attribute3%TYPE,
V_X5 ar_payment_schedules_all.terms_sequence_number%TYPE);
TYPE cur_type IS REF CURSOR RETURN get_abc_data;Package BODY is like :PROCEDURE PR_XYX_DAT(xyz_id IN NUMBER
0