Re: OC4J Bind Variables: Positional Notation

From: Christian Antognini <>
Date: Mon, 14 Jul 2008 15:47:40 +0200
Message-ID: <>

Hi Ray

> As an aside, I think in JDeveloper there is actually a
> setting to change how bind variables are submitted.

I (almost) never used JDeveloper. But, honestly, I see no reason for doing that for plain JDBC code. On the other side, when using a persistence framework, influencing the use of bind variables can be useful.

> I'm confused as to why it changes in this application.
> Can it be set in the code?

From the JDBC API point-of-view I see only one possibility. The SQL statement is executed through the class Statement instead of PreparedStatement. If you have access to the code, I would have a look to the snippet that executes one of the failing SQL statements.

Chris Antognini

Troubleshooting Oracle Performance, Apress 2008 (

Received on Mon Jul 14 2008 - 08:47:40 CDT

Original text of this message