Getting the following Error Message when run ORACLE Query in TEXT Tab.

Error in sql query: ORA-06550: line 10, column 29:
PLS-00103: Encountered the symbol "end-of-file" when expecting one of the following: ;


Declare
CURSOR c1
IS
SELECT a
FROM XXXX
WHERE fy = 2015
MINUS
SELECT a
FROM YYYY
WHERE end_date IS NULL;
BEGIN
FOR rec IN c1
LOOP
fa_xxx_pkg.process_rules_appl(rec.appl_id);
END LOOP;
END;

My guess is that VisualCron treats the semi colon as end of statement. I base that on the fact that you have the option to split multiple statements with a semi-colon. If that is the case, the sql text tab cannot be used for pl/sql or t-sql procedures. Just put the code in a procedure/package and the problem should be solved.

This is totally on the side, but I mention it anyway: I would always use implicit cursors, unless you have a good reason to use explicit cursors. They are faster for most purposes. See this discussion from the man himself (if you are interested).
https://asktom.oracle.co...UESTION_ID:1584829077861 

FOR i IN (SELECT * FROM all_objects )
LOOP
--Do something
END LOOP;


thomas

Your command text must be without the newline characters in order to execute it via our provider. The newline characters are used only for convenience and readability in PL/SQL blocks, but if you remove them, a PL/SQL block remains valid and can be executed. For example, your block will look like the following:

"Declare CURSOR c1 IS SELECT a FROM XXXX WHERE fy = 2015 MINUS SELECT a FROM YYYY WHERE end_date IS NULL; BEGIN FOR rec IN c1 LOOP fa_xxx_pkg.process_rules_appl(rec.appl_id); END LOOP; END;"

---