问题是您在触发代码PL/SQL中使用了exec. exec是SQL * Plus命令.删除exec，您的代码应该不错:

The issue is that you are using exec inside the the trigger code which is PL/SQL. exec is an SQL*Plus command. Remove exec and your code should be good:

CREATE OR REPLACE TRIGGER MY_OAM_LOG
 AFTER INSERT OR UPDATE ON OCS_CHARGE_OFF_AUTOMATION
 FOR EACH ROW 
BEGIN
  DBMS_SCHEDULER.RUN_JOB(job_name=>'test1');
END;
/

来自 PL/SQL命令参考:

执行

EXEC [UTE]语句

EXEC[UTE] statement

执行一个PL/SQL语句. EXECUTE命令通常是 当您想执行一个引用了以下内容的PL/SQL语句时很有用 存储过程.

Executes a single PL/SQL statement. The EXECUTE command is often useful when you want to execute a PL/SQL statement that references a stored procedure.

另请参阅:

See also:

• 如何执行oracle存储过程?