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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
