[gsklar]

I am using : as the parameter marker (e.g. WHERE Bill_Batch = :Bill_Batch) and receiving a syntax error. What is the correct parameter identifier for the new ODBC driver.
This is a cached copy. Click here to see the original post.

[elena]

RE: Parameters

Please try: WHERE Bill_Batch = ?

The sql connvention for passing a parameter depends on an application used to run queries.

‘WHERE Bill_Batch = :Bill_Batch’ convention works with Toad since this application was written for Oracle.

[Author]

Posts