I am using "OraOLEDB.Oracle.1" provider. I am using a
query directly instead of a stored procedure. I have some
parameters in the query which I put as ? in the query.
Then I created an OLEDBparameter for those question marks
and added to the OLEDBcommand object. When I execute the
query, it always displays error message as 'ORA-00936:
missing expression'. Please help me resolve the issue.
(I am sure there is no syntax error in the query because
it runs well if I run the query in sqlplus).