Getting the parameter values for a stored procedure

[Sampath]

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.

Regards,
Sampath.

[Tim...]

Hi.

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.

Cheers

Tim...