Home » Developer & Programmer » JDeveloper, Java & XML » Multiple Version are being made in Oracle for certain SQL's due to bind variable mismatchwith Oracle (PL/SQL DEVELOPER , ECLIPSE )
Multiple Version are being made in Oracle for certain SQL's due to bind variable mismatchwith Oracle [message #452344] Wed, 21 April 2010 08:16 Go to next message
neetigyajain
Messages: 4
Registered: April 2010
Junior Member
Hi All,

I am bugged up with a problem pertaining to multiple versions of same SQL_ID in database.

Problem:
For a column defined as number in both Java boundary and Oracle Database . While executing a query multiple versions are getting created for same SQL_ID.

Code implementation is shown below:
if ( null != boundary.getSalary() ){
statement.setObject(1, boundary.getSalary() );
}
else{
statement.setNull(1,Types.Numeric);
}

I am using oraclejdbc.jar to interact with the Oracle database.

Problem is when above Query is executed Several instances of Same SQL_ID is created in DB leading to an additional Overhead on DB. I am unable to figure out the exact root cause for the same. It would be of immense help if someone can advise on the same.

Eagerly awaiting for response.
Thanks in Advance.
Re: Multiple Version are being made in Oracle for certain SQL's due to bind variable mismatchwith Or [message #452353 is a reply to message #452344] Wed, 21 April 2010 09:04 Go to previous message
Michel Cadot
Messages: 67137
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Check the following reasons:
http://www.orafaq.com/wiki/Parsing#Shared_statements

Regards
Michel
Previous Topic: XML From BLOB
Next Topic: how to find the count of attachments done before submit in Attachment Link
Goto Forum:
  


Current Time: Sat May 30 06:46:17 CDT 2020