> |  TYPEPayment_Capabilities  IS RECORD( pp_partial_payment NUMBER(1)
> DEFAULT0, co_advance_payment NUMBER(1)  DEFAULT0, dp_deposit_payment
> NUMBER(1)  DEFAULT0, dr_deposit_repay   NUMBER(1)  DEFAULT0,
> wp_wallet_payment  NUMBER(1)  DEFAULT0, wr_wallet_repay    NUMBER(1)
> DEFAULT0, ss_prepaid_payment NUMBER(1)  DEFAULT0);

> |and function which returns this type. I use MyBatis integration with
> Spring. How to call (using MyBatis XML Mapper) this function and map
> result to POJO object?

> On 9/6/2012 1:08 AM, Tural Muradbeyli wrote:

>> I have record type in package specification:

>> |  TYPEPayment_Capabilities  IS RECORD( pp_partial_payment NUMBER(1)
>> DEFAULT0, co_advance_payment NUMBER(1)  DEFAULT0, dp_deposit_payment
>> NUMBER(1)  DEFAULT0, dr_deposit_repay   NUMBER(1)  DEFAULT0,
>> wp_wallet_payment  NUMBER(1)  DEFAULT0, wr_wallet_repay    NUMBER(1)
>> DEFAULT0, ss_prepaid_payment NUMBER(1)  DEFAULT0);

>> |and function which returns this type. I use MyBatis integration with
>> Spring. How to call (using MyBatis XML Mapper) this function and map
>> result to POJO object?

> --
> Guy Rouillier

> <select id="identifyPaymentCapabilities" parameterType="PaymentCapabilities" statementType="CALLABLE">
>     DECLARE
>         v_payment_capabilities APS.Payment_Capabilities;
>     BEGIN
>         v_payment_capabilities := APS.get_payment_capabilities(#{customerId, javaType=Integer, jdbcType=NUMERIC, mode=IN});

>         #{partialPaymentPP, javaType=Integer, jdbcType=NUMERIC, mode=OUT} := v_payment_capabilities.pp_partial_payment;
>         #{advancePaymentCO, javaType=Integer, jdbcType=NUMERIC, mode=OUT} := v_payment_capabilities.co_advance_payment;
>         #{depositPaymentDP, javaType=Integer, jdbcType=NUMERIC, mode=OUT} := v_payment_capabilities.dp_deposit_payment;
>         #{depositRepayDR,   javaType=Integer, jdbcType=NUMERIC, mode=OUT} := v_payment_capabilities.dr_deposit_repay;
>         #{walletPaymentWP,  javaType=Integer, jdbcType=NUMERIC, mode=OUT} := v_payment_capabilities.wp_wallet_payment;
>         #{walletRepayWR,    javaType=Integer, jdbcType=NUMERIC, mode=OUT} := v_payment_capabilities.wr_wallet_repay;
>         #{prepaidPaymentSS, javaType=Integer, jdbcType=NUMERIC, mode=OUT} := v_payment_capabilities.ss_prepaid_payment;
>     END;
> </select>

On Thursday, September 6, 2012 10:08:03 AM UTC+5, Tural Muradbeyli wrote:

> I have record type in package specification:

>  TYPE Payment_Capabilities IS RECORD(
>     pp_partial_payment NUMBER(1) DEFAULT 0,
>     co_advance_payment NUMBER(1) DEFAULT 0,
>     dp_deposit_payment NUMBER(1) DEFAULT 0,
>     dr_deposit_repay   NUMBER(1) DEFAULT 0,
>     wp_wallet_payment  NUMBER(1) DEFAULT 0,
>     wr_wallet_repay    NUMBER(1) DEFAULT 0,
>     ss_prepaid_payment NUMBER(1) DEFAULT 0);

> and function which returns this type. I use MyBatis integration with Spring. How to call (using MyBatis XML Mapper) this function and map result to POJO object?

> I have record type in package specification:

>  TYPE Payment_Capabilities IS RECORD(
>     pp_partial_payment NUMBER(1) DEFAULT 0,
>     co_advance_payment NUMBER(1) DEFAULT 0,
>     dp_deposit_payment NUMBER(1) DEFAULT 0,
>     dr_deposit_repay   NUMBER(1) DEFAULT 0,
>     wp_wallet_payment  NUMBER(1) DEFAULT 0,
>     wr_wallet_repay    NUMBER(1) DEFAULT 0,
>     ss_prepaid_payment NUMBER(1) DEFAULT 0);

> and function which returns this type. I use MyBatis integration with Spring. How to call (using MyBatis XML Mapper) this function and map result to POJO object?