ignoring OUT from Oracle procedure

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

ignoring OUT from Oracle procedure

Paweł P.
I call Oracle procedure, which has parameters declared as OUT.
It looks like this:

CREATE OR REPLACE PROCEDURE PROC1(
        ATR1 IN NUMBER,
        ATR2 IN VARCHAR2,
        ATR3 OUT NUMBER) AS .......

As a parameter do myBatis I send object (kind of DTO), which has only
2 params (atr1, atr2).
I map atr1 to ATR1, atr2 TO ATR2.
My question:

How to ignore ATR3 from procedure. I don't want to use a map as a
param to ibatis.
Is there any way to ignore these OUT param in ma mapping?
Writing 'null' doesn't work.

Example:
<select id="callProc1" statementType="CALLABLE">
                { call PROC1(
                        #{atr1, mode=IN, jdbcType=NUMERIC,
javaType=java.lang.Integer},
                        #{atr2, mode=IN, jdbcType=VARCHAR, javaType=java.lang.String},
                        #{UNWANTED_OUT}
                )
        }
  </select>


Best regards
Pawel
Loading...