How to call PL/SQL procedure in Ibatis from java

Question

I have written a PLSQL stored procedure , i want to call the procedure and return the resultset back to the java in a hashmap or arraylist format . I want to configure it in the xml file using Ibatis. kindly let me know how to configure in Ibatis.

Answer 1

<procedure id="yourProc" parameterClass="yourclass" resultMap="result">
    {call yourProc(#param1#,#param2#)}
</procedure>