PLS-00103: Encountered the symbol "end-of-file

General Discussion
1

I have ansible script that drops all schema by drop-all and delete db-link by command:

  • name: Drop database link & package
    command: >
    …/libs/liquibase/liquibase execute-sql
    –sql=“DROP DATABASE LINK DB_LINK; DROP PACKAGE pkg”
    failed_when: false

There is SCHEDULER JOB in schema and I want to delete it also.
On the command line I deleted by:
Begin
DBMS_SCHEDULER.DROP_JOB(job_name => ‘“USER”.“DICT_REFRESH”’);
END;
/

or
EXEC DBMS_SCHEDULER.DROP_JOB(job_name => ‘“USER”.“DICT_REFRESH”’);

But when I try to execute:

  • name: Delete scheduler job
    command: >
    …/libs/liquibase/liquibase execute-sql
    –sql=“Begin DBMS_SCHEDULER.DROP_JOB(job_name => ‘“USER”.“DICT_REFRESH”’); END; /”
    failed_when: false
    I’ve got an error: PLS-00103: Encountered the symbol “end-of-file” when expecting one of the following: ;

Is it possible to execute several commands?

2

You need to set endDelimiter=/. I’m not sure which changelog format you are using so you will have to determine the proper way to set that for your situation.