Re: OC4J Bind Variables: Positional Notation
Date: Tue, 15 Jul 2008 15:19:33 +1000
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.
RayReceived on Tue Jul 15 2008 - 00:19:33 CDT