ORA-20001: comma-separated list invalid near .... ( Another misleading oracle error message )

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"') ;