CODEWITHSUNDEEP
asp.netoracle-databaseparameters
johnny
johnny

Reputation: 19735

How do you build a parameter query for Oracle with Visual Web Developer 2010?

I am using a dataset and have build my tableAdapter in VWD. In SQL Server you can use an @somevar to be the parameter. But what do you put in Oracle to make it look for a parameter so that I can later bind it to a textbox? I tried ? but it did not work.

Upvotes: 0

Views: 679

Answers (1)

ventaur
ventaur

Reputation: 1851

I believe Oracle PSQL expects parameters of a query to use a colon (":") instead of "@". So, try :somevar.

Upvotes: 2

Related Questions