We are working on an application which uses JAVA as Front end and ORACLE11g as back end.
We are receing exceptions from ORACLE.
Can you please tell me is there any way to know what are the parameters(parameter values) that passed to a particular stored procedure from JAVA application without debugging the JAVA aplication.
If TKPROF is used, it will record all the SQL statements and their related information(hard parse or soft parse, elapsed time,how many rows processed etc.) in a trace file on ORACLE server.
But I want to know is there any way to get all the parameters that are being passed to a ORACLE stored proc from JAVA application.If we can get these parameters, how to retrive them?
Thanks in advance.
The most effective way to do this is to add trace to the Java.
TKPROF will capture bind variable values if instructed to do so, but only on top level PL/SQL and SQL, so if this suits your purpose, then great. As you said, all the trace is done on the server.
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: https://oracle-base.com
My blog: https://oracle-base.com/blog
Who is online
Users browsing this forum: No registered users and 1 guest