Skip to Main Content
Forums

Java Development Tools

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Bind Variables when issuing query to SQL Server

castrogenerisNov 15 2012 — edited Nov 16 2012
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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 14 2012
Added on Nov 15 2012
#application-development-in-java, #jdeveloper-and-adf
2 comments
1,122 views