SQL Invalid syntax with OLEDB Oracle (11g) and C#

Question

Here is the query I want to run:

SELECT COUNT(*) FROM Users WHERE name = @name AND pwd = @pwd;

My Connection String:

Provider=OraOLEDB.Oracle;User Id = HR; Password = hr;

Specifications:

Steps I've tried:

Error I'm getting:

ORA-00936: missing expression

Patrick Hofman · Accepted Answer · 2016-04-26 09:03:54Z

1

In Oracle, parameters are prefixed with : instead of @. Use that instead:

SELECT COUNT(*) FROM Users WHERE name = :name AND pwd = :pwd;

answered Apr 26, 2016 at 9:03

Patrick Hofman

158k23 gold badges270 silver badges343 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1