Hi, after upgrading our databases from 12c to 19, creating or editing scheduled jobs with sql developer fails if you make any changes to the 'notification' tab.
Error shown on attempting to apply changes:
in text:
Failed to process SQL Command
ORA-06550: line 4, column 1
PLS-00103: Encountered the symbol "NULL" when expecting one of the following:
;
the symbol "; was inserted before "NULL" to continue.
I've no idea whether this is an issue with SQL Developer, DB 19, or with something we've done during the upgrade (I am not the dba).
It was noticed because after upgrade the jobs all had some extra recipients and event triggers for notifications (e.g. job_succeeded) and I needed to fix them (this may well be the root cause, but still none the wiser why!)
I can work around it at the moment by using the PL/SQL DBMS_SCHEDULAR API.
Any ideas on how we can proceed to investigate further would be welcome. I have searched the support KB and on here to no avail so far.
SQL Developer versions tested:
Java(TM) Platform 1.8.0_212
Oracle IDE 19.2.0.206.2117
Versioning Support 19.2.0.206.2117
Java(TM) Platform 1.8.0_221
Oracle IDE 19.4.0.354.1759
Versioning Support 19.4.0.354.1759
DB version that works OK:
Product: Oracle Database 12c Enterprise Edition
Version: 12.2.0.1.0
Status: 64bit Production
(upgraded) DB Version that exhibits the issue:
Product: Oracle Database 19c Enterprise Edition
Version: 19.0.0.0.0
Version Full: 19.6.0.0.0
Status: Production
Cheers.