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!

Correct Way to use Bind variables when using an MS SQL server backend

770890Dec 15 2010 — edited Dec 16 2010
Hey,
I'm having some trouble figuring out how to use bind variables in a view when using an MS SQL server backend. For some reason when I'm using an ApplicationModule that has a MS SQL Server JDBC library loaded and I attempt to click OK when editing the following query:

SELECT kit_status, component_id
FROM numbered_inv
WHERE trialname = :1

I get an error stating that "SQL Query Error Message Incorrect Syntax near ':'". Is JDeveloper compatible with SQL server for bind variables because this query runs just fine if I replace the :1 with a say "Testing testing".

Thanks in advance

Edited by: NullCheck on Dec 15, 2010 2:06 PM
This post has been answered by Shay Shmeltzer-Oracle on Dec 15 2010
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 13 2011
Added on Dec 15 2010
#application-development-in-java, #jdeveloper-and-adf
2 comments
403 views