Skip to Main Content
Forums

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

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

EdStevensMay 8 2019 — edited May 9 2019

Oracle 12.1.0.2 SE-2

SQL Dev 18.3.0.277

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:

pastedImage_0.png

And when I try to run it

pastedImage_1.png

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?
This post has been answered by thatJeffSmith-Oracle on May 9 2019
Jump to Answer
Comments
Post Details
Added on May 8 2019
#sql-developer
3 comments
785 views