The ibatis documentation provides a sample on how to call a procedure, but how do you call a function in Oracle? The code sample shows it. <parameterMap id="getSomeFunction" class="java.util.Map" > <parameter property="question1" jdbcType="INTEGER" javaType="java.lang.String" mode="OUT"/> <parameter property="question2" jdbcType="VARCHAR" javaType="java.lang.String" mode="IN"/> <parameter property="question3" jdbcType="INTEGER" javaType="java.lang.String" mode="IN"/> <parameter property="question54" jdbcType="VARCHAR" javaType="java.lang.String" mode="IN"/> <parameter property="question5" jdbcType="VARCHAR" javaType="java.lang.String" mode="IN"/> </parameterMap> <procedure id="getSomeFunction" parameterMap="getSomeFunction"> {? = call FNC_EXECUTE_SOME_FUNCTION(?, ?, ?, ?)} </procedure>

Finally I managed to connect to the remote database using Oracle Connection Manager, after struggling for almost a week. The requirement requires the Oracle connection and firewalls. A remote Oracle client making a connection to an Oracle database can fail if there is a firewall installed between the client and the server if port redirection is taking place.The firewall will block the connection to the new port when the Oracle client connects to the database  ORA12203 or ORA-12535 or ORA-12564. The client connection failure is due to port redirection from the Database Server‘s operating system. Port redirection requires the client to connect to the database using a different port than originally configured in the configuration files. Actually, it is not difficult if you know but