This forum is currently locked. You can't register or post questions at this time. (read more)

Getting the parameter values for a stored procedure

All posts relating to Oracle PL/SQL development.

Moderator: Tim...

Sampath
Member
Posts: 39
Joined: Wed Aug 12, 2009 3:40 pm

Getting the parameter values for a stored procedure

Postby Sampath » Mon Feb 11, 2013 1:20 pm

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...
Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK
Contact:

Re: Getting the parameter values for a stored procedure

Postby Tim... » Mon Feb 11, 2013 3:42 pm

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...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog


Return to “Oracle SQL and PL/SQL Development”

Who is online

Users browsing this forum: No registered users and 8 guests

cron