Results 1 to 3 of 3
  1. #1
    Join Date
    May 2002
    Posts
    18

    Unanswered: ADO.NET - Parameter to Query

    Hi all,
    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).

  2. #2
    Join Date
    Dec 2003
    Posts
    4

    Perhaps Oracle Client

    Hi,

    Check the version of the Oracle Client if it's the same version on the server (database version). I think it can be the problem.

    BR,

    Thierry

  3. #3
    Join Date
    Dec 2003
    Posts
    4

    web link


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •