3 Replies Latest reply on May 9, 2019 1:35 PM by thatJeffSmith-Oracle

    ORA-00922: missing or invalid option - while running user defined report.


      Oracle SE-2

      SQL Dev


      So, while I'm not a complete stranger to creating user-defined reports, it's not something I do a lot of.

      I create a report:





      And when I try to run it



      So I would like to buy a clue as to what it thinks is missing or invalid.  The exact same script, pasted into a SQL Dev worksheet, performs perfectly.

      Ok, so on a guess I commented out the SET, COL, and BREAK commands.  Now the report runs, but of course without any of the formatting I intended.  Am I overlooking something, or expecting what really isn't there?