Re: OC4J Bind Variables: Positional Notation

From: Ray Feighery <rjfeighery_at_gmail.com>
Date: Tue, 15 Jul 2008 15:19:33 +1000
Message-ID: <8214a88a0807142219m4fe984a2vbe88f9dccb9cb4e1@mail.gmail.com>

Thanks for all the replies.

The SQL statements are stored in XML files. The XML files have a parameter called BindingStyle which is set to either JDBC or Oracle. When it is set the JDBC the variables are denoted by a '?'. When it is set to Oracle the variables are denoted by ':1' (or :2,:3).

Changing them does not seem to make any difference.

There is a bug 5510048 filed on Metalink against JDeveloper which seems similar; using different BindingStyles results in an error.

I'll update if I find a solution.

Ray

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Jul 15 2008 - 00:19:33 CDT

This message: [ Message body ]
Next message: Douglas Cowles: "Re: rman Ora-4031 - how to flush large pool?"
Previous message: Douglas Cowles: "Re: rman Ora-4031 - how to flush large pool?"
Maybe in reply to: Ray Feighery: "OC4J Bind Variables: Positional Notation"
Next in thread: jaromir nemec: "Re: OC4J Bind Variables: Positional Notation"
Reply: jaromir nemec: "Re: OC4J Bind Variables: Positional Notation"
Reply: Yechiel Adar: "Re: OC4J Bind Variables: Positional Notation"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message