Skip to Main Content

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

it wants a sql query, but you gave it sqlplus commands instead

back up a level and share the type of report you have, and what kind of output you want, grid, chart, report, html, etc...

EdStevens

thatJeffSmith-Oracle wrote:

it wants a sql query, but you gave it sqlplus commands instead

back up a level and share the type of report you have, and what kind of output you want, grid, chart, report, html, etc...

Just a simple report, with the formatting as suggested by the sqlplus commands that were shown.

Answer

if you want to use the sql formatting stuff, set your report type to script

pastedImage_0.png

Then you can have at it...but instead of using COL formats, why not try SET SQLFORMAT ansiconsole?

pastedImage_1.png

Marked as Answer by EdStevens · Sep 27 2020
1 - 3

Post Details

Added on May 8 2019
3 comments
783 views