2 Replies Latest reply: Nov 16, 2012 12:56 AM by Frank Nimphius-Oracle RSS

    Bind Variables when issuing query to SQL Server

    castrogeneris
      Hi,

      I need to use bind variables for a VO, the connection is pointing to a MS SQL Server when testing with this simple query:

      SELECT OrderCommit.Clienteid,
      OrderCommit.EmpresaId,
      OrderCommit.Nombre,
      OrderCommit.OrderCommitID,
      OrderCommit.SeasonId
      FROM dbo.Master_OrderCommit OrderCommit
      WHERE seasonid = :pSeason

      the error i get is:
      com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near ':'.

      If for SQL server I need use positional bind variables please show me some examples.

      Thanks