Oracle - PLS-00103: Encountered the symbol "END" when try to create JOB
Solution 1:
You need a semicolon at the end of the "what" parameter. Use 'SP_DEL_TOKEN;'
instead of 'SP_DEL_TOKEN'
. See the manual for some more examples.
I'm not sure why this is. With dynamic SQL you cannot have a semicolon, and with dynamic PL/SQL you need the BEGIN
and END;
. I guess this parameter is used in some weird context.