Re: OC4J Bind Variables: Positional Notation
- From: "Cary Millsap" <cary.millsap@xxxxxxxxxxxx>
- To: rjfeighery@xxxxxxxxx
- Date: Fri, 11 Jul 2008 09:37:38 -0500
Ray,
I *think* that if you execute an extended SQL trace with
dbms_monitor.session_trace_enable(null,null,true,true) upon the simple test
case you show here, you'll see evidence of the conversion you're wondering
about in your trace file.
Cary
On Thu, Jul 10, 2008 at 8:47 PM, Ray Feighery <rjfeighery@xxxxxxxxx> wrote:
> 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:
