Announcement

Collapse
No announcement yet.

​ORA-00911: invalid character when exporting

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • ​ORA-00911: invalid character when exporting

    I am trying to export my query results into an excel file but every time I try to export them, I get a "​ORA-00911: invalid character" error. Does anyone have any idea as to why this is happening?

  • #2
    Could you please provide the whole query for investigation?

    Comment


    • #3
      select student_number, last_name, first_name, entrydate, transfercomment
      from students
      where enroll_status = 0 and entrycode in (01,02) and entrydate >= to_date('08/15/2013', 'mm/dd/yyyy')
      order by last_name;

      It's not only this one, it happens with all of the queries I have.

      Comment


      • #4
        remove the ; at the end of select stmt

        Comment


        • #5
          It worked...thank you

          Comment

          Working...
          X