Re: OC4J Bind Variables: Positional Notation

From: Ray Feighery <>
Date: Thu, 24 Jul 2008 16:17:02 +1000
Message-ID: <>

Hello All

The actual problem turned out to be a mismatch between binding styles. One of the processes reads the XML for the SQL query. The query was set to Binding Style Oracle. The process then adds a "WHERE (col1 = ? and col2 = ?);" clause to the select statement. As the Binding Style had already been set to Oracle the '?' notation causes the error.

Crucially the process and the XML were set to different binding styles.As noted above, the JDBC driver could handle both, but not at the same time.

Solution: Be consistent.

Thanks for all the replies


Received on Thu Jul 24 2008 - 01:17:02 CDT

Original text of this message