Using VS2005. I have created a dataset for our Oracle database and have created a TableAdapter within the dataset for one of the Oracle tables.

When I Add a Query, I want to create a SELECT statement with a parameter as such:

SELECT * FROM customer WHERE custno = @lccustno

However, when I get to the Finish page of the dialog, I get an error "Missing expression".

My question is, how do I define a parameter on a SELECT statement for an Oracle table? The '@' works on a Sql Server table but not on an Oracle table.

Thanks,

Jerry