I have been asked to schedule a report to run on a monthly basis. The report is already written and is part of an application which contains dozens of reports to be run by staff as needed. I am brand new to APEX so I'll do my best with names/descriptions of things within this system.
I have tried to a scheduler interface to run the report but it exceeds the 4000 character limit so I am unable to paste it into the JOB ACTIONS Section.
Similarly, I've tried creating an automation within the application that contains this report. The SQL fits into the executable area here but doesn't appear to use PLSQL syntax? I get the following error: ORA-06550: line 2, column 1: PLS-00428: an INTO clause is expected in this SELECT statement
Here are lines 1-4:
begin
WITH CF_TEXT_ALERTS
AS (SELECT
DISTINCT
This report runs when executed ad hoc in APEX and syntactically, I can't find anything wrong with it or why an INTO would be necessary.