Re: OC4J Bind Variables: Positional Notation
- From: Yechiel Adar <adar666@xxxxxxxxxxxx>
- Date: Wed, 16 Jul 2008 14:51:04 +0300
You may want to check the NLS_LANG settings.
If I am not mistaken, '?' is unknown character in USASCII7, meaning you
have a value, length 1 character, that does not translate between the
client and the server.
Adar Yechiel
Rechovot, Israel
Ray Feighery wrote:
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
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
