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.

EdStevens May 8, 2019 7:22 PM

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:

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?

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

thatJeffSmith-Oracle May 8, 2019 8:16 PM (in response to EdStevens)

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...
Like Show 0 Likes(0)

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

EdStevens May 9, 2019 1:15 PM (in response to thatJeffSmith-Oracle)

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.
Like Show 0 Likes(0)

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

thatJeffSmith-Oracle May 9, 2019 1:35 PM (in response to EdStevens)

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

Then you can have at it...but instead of using COL formats, why not try SET SQLFORMAT ansiconsole?
Like Show 0 Likes(0)

Actions

Go to original post