Uploaded image for project: 'NHibernate [Moved to GitHub]'
  1. NH-2792

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

    Details

    • Sprint:

      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).

        Attachments

          Issue links

            Activity

              People

              • Assignee:
                flukefan Richard Brown
                Reporter:
                cremor cremor
              • Votes:
                2 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Who's Looking?