OraFAQ Forum: JDeveloper, Java & XML » Multiple Version are being made in Oracle for certain SQL's due to bind variable mismatchwith Oracle

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 )

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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

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.

Report message to a moderator