MyBatis annotations to call Stored Procedure and get Out Params
This post has NOT been accepted by the mailing list yet.
I am using MyBAtis-3 with MyBAtis-Spring.
When i tried to call a stored procedure that returns more than one out params using MyBatis annotations. I don't get anything, I can see that the input parameter is passed to the SP in the logs and it hangs in there with no progress nor exception thrown.
PFB the Oracle Stored Procedure which i am trying to access from MyBAtis,
create or replace PROCEDURE C2C.GET_DATA
"IN_PARAM1" IN NUMBER,
"OUT_PARAM2" OUT SAMPLETABLE.COL2%TYPE,
"OUT_PARAM3" OUT SAMPLETABLE.COL3%TYPE,
"OUT_PARAM4" OUT SAMPLETABLE.COL4%TYPE
SELECT PARAM2,PARAM3,PARAM4 INTO
FROM C2C.SAMPLETABLE WHERE PARAM1=IN_PARAM1 ;