Good Morning Tim,
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.