Some times , you wonder why Oracle would give non-useful error message as below .
I was trying to run one of the scheduler job manually . I bumped into ORA-20001 . It was not informational error message . There was no command separated values in the command . Was able to fix and run the job when I enclosed into double quotes.
exec DBMS_SCHEDULER.run_job('DATA REPOSITRY')
Error report:
ORA-20001: comma-separated list invalid near Y
ORA-06512: at "SYS.DBMS_UTILITY", line 272
ORA-06512: at "SYS.DBMS_SCHEDULER", line 482
ORA-06512: at line 1
The correct usage of the command .
exec DBMS_SCHEDULER.run_job('"DATA REPOSITRY"') ;
