Oracle JDBC Bind Variable Corruption - Wrong Values in Bind Data when Resetting some Variable in a Loop (Doc ID 2549568.1)

Last updated on FEBRUARY 02, 2024

Applies to:

Symptoms

When using Oracle WebLogic Server with JDBC connections within an application. When executing a prepared statement in loop with bind variables, on subsequent updates the bind variables are being corrupted.

Here is the detailed description:

• In the context of 1 transaction, created a PreparedStatement with 120 bind variables. It's been used to execute 2 updates.
• 1st 20 bind variables do not change between 2 updates. Other 100 bind variables do.
• Set all 120 bind variables and execute 1st update. (it works fine)
• Without touching 1st 20 bind variables set other 100 to new values and execute update.
• 2nd update does not fail but it does not work. When checked the trace from DB end it seems some of the bind variables got incorrect values.

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.