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 overall took me few days ding dong here and there trial and error where to place the CMAN and wat IP address to use. Many thanks to Prince Amin who show me the Network Structure and advice me to place the CMAN at the Remote Site. I was blur at that time. Two heads is better than One !!!! Prince Amin, I owe you dude…..
Read the rest of this entry »
Sample TKPROF Out from a sample trace file.
call count cpu elapsed disk query current rows
——- —– —— ——- — ——– ——— - — — — — Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 2 1.20 1.21 0 86091 4 15
——- —– —— ——- — ——– ——— - — — — — total 4 1.20 1.21 0 86091 4 15
1. A high (near 100%) parse count to execute count ratio when the execute count is greater 1 – if ratio is 1, then the query is parsed each and every time its execute and that needs to be corrected. The ratio should approach zero. The ideal is parse count should be 1 and execute count would be higer. If high parse count this indicate the query performing many soft parse.
Read the rest of this entry »
Go Job Hunting
See the Internet Learning Institute of the best places to find jobs on the Internet. Be sure to read our job hunting tips. This will help you achieve success quickly
Tuition Payment Plan
Find out if you qualify for our tuition payment plan. Pay for your courses in installments. Read the rest of this entry »
Targeted Fast Affordable 100% Hands-on 100% Instructor-led No Time Commitment No Place Commitment View all courses Do you have a related personal or work project you are working on? If you do, you can discuss your project with your instructor and request to use it as a basis for your course final project. Note that the project must be within the course limits and it must include all the concepts covered in class. Get trained anywhere in the world! The Internet Learning Institute is a 100% Hands-on Instructor-led online training school. Read the rest of this entry »
Hundreds of Students are enjoying the benefits of our 100% Hands-On Instructor -Led Online Training Programs. Here are some of the benefits: Instructor-Led Training Server Space Convenient Schedule 24Hour Access Live Instructor Support Free Server Space (1yr) Developer Certificate Read the rest of this entry »
Monster Monster is the most popular job search resource available on the internet today. Search monster for all IT Jobs in all US states.CareerBuilder Careerbuilder is the parent company of former the headhunter.net, CareerMosaic, and CareerPath. Read the rest of this entry »