PL/SQL (MOSC)

MOSC Banner

Invoking a proecdure having REFCURSOR as IN OUT parameter

edited Sep 22, 2013 10:24PM in PL/SQL (MOSC) 1 commentAnswered
Hi there,

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

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