i used this code
Insert into c Select * from b begin dbms_scheduler.create_job1w ( job_name => 'streams_heartbeat_job', job_type => 'PLSQL_BLOCK', job_action => 'Insert into c Select * from b;', start_date => SYSTIMESTAMP, repeat_interval => 'freq=secondly; interval=15', enabled => TRUE, comments => 'Streams heartbeat job from site A' ); end
Error: -----
dbms_scheduler.create_job1w * ERROR at line 3: ORA-00933: SQL command not properly ended
Where error is there please any one help me
Thanks, Malleswari.
|
| Author: D.Jeya kumar(JK) 29 Aug 2008 | Member Level: Diamond | Rating: Points: 3 |
Hi,
run this statement alone in oracle and see what error it is throwing?
Insert into c Select * from b;
is both the table c and b have same structure?
Regards JK
|
| Author: D.Jeya kumar(JK) 29 Aug 2008 | Member Level: Diamond | Rating: Points: 4 |
Hi,
Use this code
begin dbms_scheduler.create_job1w ( job_name => 'streams_heartbeat_job', job_type => 'PLSQL_BLOCK', job_action => 'Insert into c Select * from b;', start_date => SYSTIMESTAMP, repeat_interval => 'freq=secondly; interval=15', enabled => TRUE, comments => 'Streams heartbeat job from site A' ); end
Regards JK
|