Skip to Main Content

SQL & PL/SQL

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!

Error ORA-00923. No idea why

707639Jun 18 2009 — edited Jun 18 2009
I have googled and looked for a reason that this error comes up with no success that fixes my problem.

I am trying to export a query as a csv from my database which works fine. The problem comes when i try to add 2 columns during the query and export those as well for organizational purposes. The new query runs fine with a perfect output, but when i try to export it i get ORA-00923 Error.

SELECT fcp.concurrent_program_name AS SHORTNAME,
fcp.user_concurrent_program_name AS NAMER,
fcp.description AS DESCRIPTION,
fcp.output_file_type AS OUTPUTTYPE,


'STAR' AS SOURCEDB, --These are the 2 lines that when added cause the error to come up during export
'' AS KEYWORDS, -- The query runs fine, just doesnt export


fa.application_short_name AS APPLICATIONSN
FROM fnd_concurrent_programs_vl fcp
JOIN fnd_application_vl fa ON fa.application_id = fcp.application_id
WHERE fcp.execution_method_code = 'P'


Some more important information may be, like i said, that those 2 columns dont really exist in the table, but i am using the query to create them right before i export.

Thanks in advance.
This post has been answered by SomeoneElse on Jun 18 2009
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 16 2009
Added on Jun 18 2009
15 comments
3,233 views