Error ORA-00923. No idea why
707639Jun 18 2009 — edited Jun 18 2009I 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.