Re: OC4J Bind Variables: Positional Notation

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

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