4 Replies Latest reply: Jun 6, 2012 7:56 AM by Christian Erlinger RSS

    Unable to Execute QUery ORA -00911 Probably Oracle Bug Please confirm

    889303
      HI Gurus,

      Unable to run the query:
      Was able to run select query fine, was able to run insert query fine...but when combining and running, its throwng the follwoing error:
      Is this a bug in ORacle?

      Error starting at line 1 in command:
      INSERT INTO MigrationCorrespData1(did) SELECT did from revisions where (dInDate >={ts '2011-09-01 00:00:01'} and dInDate <={ts '2012-01-01 23:59:59'})
      Error at Command Line:1 Column:80
      Error report:
      SQL Error: ORA-00911: invalid character