We're updating the issue view to help you get more done. 

Using a named parameter multiple times in a native SQL query results in invalid parameter binding (exception in some drivers)

Description

The attached test executes a native SQL query in which a named parameter is used multiple times. This results in multiple parameters (with equal values) in the parameters collection of the command object. But these parameters are not all used in the generated plain SQL query (all parameters are named equally there).

Seems like this isn't a problem when using SQLite, but the OracleDataClientDriver throws an exception (ORA-01036: illegal variable name/number).

Environment

None

Status

Assignee

Richard Brown

Reporter

cremor