# OC4J Bind Variables: Positional Notation

*From*: "Ray Feighery" <rjfeighery@xxxxxxxxx>*To*: "Oracle-L List" <oracle-l@xxxxxxxxxxxxx>*Date*: Fri, 11 Jul 2008 11:47:36 +1000

Hello All Red Hat Linux 4.0 Oracle Database 10.1.0.5 Oracle Application Server 10.1.2.0.2 An OC4J application that had been running on Oracle Application Server 9.0.4.3 has recently been upgraded. Since then queries have been failing as they are being submitted like this: SELECT * from table1 WHERE (col1 = ? and col2 = ?); instead of SELECT * from table1 WHERE (col1 = :b1 and col2 = :b2); This is more like an ODBC or Perl query using positional placeholders. I had thought that the jdbc driver handled this and converted the former to the latter. Has anyone seen this before or know what setting controls this? Google and Metalink are not showing anything similar. Ray -- http://www.freelists.org/webpage/oracle-l

**Follow-Ups**:**Re: OC4J Bind Variables: Positional Notation***From:*Cary Millsap

## Other related posts:

- » OC4J Bind Variables: Positional Notation
- » Re: OC4J Bind Variables: Positional Notation
- » RE: OC4J Bind Variables: Positional Notation
- » Re: OC4J Bind Variables: Positional Notation
- » RE: OC4J Bind Variables: Positional Notation
- » Re: OC4J Bind Variables: Positional Notation
- » Re: OC4J Bind Variables: Positional Notation
- » Re: OC4J Bind Variables: Positional Notation
- » Re: OC4J Bind Variables: Positional Notation
- » RE: OC4J Bind Variables: Positional Notation
- » Re: OC4J Bind Variables: Positional Notation
- » Re: OC4J Bind Variables: Positional Notation
- » Re: OC4J Bind Variables: Positional Notation
- » Re: OC4J Bind Variables: Positional Notation