begin 
DBMS_SCHEDULER. CREATE_SCHEDULE (
Schedule_name=& gt; 'BPH_START_TRACE_SCHEDULE' 
The start_date=& gt; To_date (to_char (sysdate, 'yyyy - MM - dd) | |' 15:00:00 ', '- dd yyyy - MM hh24: mi: ss'), 
Repeat_interval=& gt; 'the FREQ=DAILY; The INTERVAL=1 ', 
Comments=& gt; 'every one day 10 PM start trace'); 
END; 

The BEGIN 
DBMS_SCHEDULER. CREATE_PROGRAM (
Program_name=& gt; 'BPH_START_TRACE_PROGEAM' 
Program_action=& gt; 'the begin 
The EXECUTE IMMEDIATE the alter system set sql_trace=true; 
End, '
Program_type=& gt; 'PLSQL_BLOCK' 
Enabled=& gt; TRUE); 
END; 

The BEGIN 
DBMS_SCHEDULER. CREATE_JOB (
Job_name=& gt; 'BPH_START_TRACE_JOB' 
Program_name=& gt; 'BPH_START_TRACE_PROGEAM' 
Schedule_name=& gt; 'BPH_START_TRACE_SCHEDULE' 
Enabled=& gt; True); 
END; 

Why the implementation of the above quote is unusual, JOB execution is not successful?
Below is the abnormal information

 ORA - 06550: line 2, 57 columns: 
PLS - 00103: "ALTER" a symbol in need one of the following: 
(- + case 
The mod new not null & lt; The an identifier> 
  
The continue avg count current exists Max min the prior SQL stddev 
The sum variance execute forall the merge time timestamp interval 
The date & lt; A string literal with character set specification> 
 

CodePudding user response:

Bosses, please help to give directions