Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2003
    Posts
    144

    Question Unanswered: "Invalid character" error when using an ADO Recordset to run a query

    Hello

    I want to open an ADO Recordset using the Oracle OLE DB Provider for 11g. The query runs when execute in the SQL*Plus utility. However, an ORA-911 "Invalid character" error is raised when trying to use the Open method of the recordset. What could be happening?

    My PC uses WinXP SP2, and the target database is within a 9i server. The query is 13K long.



    Thanks a lot.

  2. #2
    Join Date
    Mar 2003
    Posts
    144

    Not using ";" at the end is the answer

    I have just discovered that placing a ";" at the end of the statement was causing the error.

Posting Permissions

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