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
|