Delay Time when executing sql command

[kirubagari]

Attach my sql and i need to put wait for delay command so that the sql will process after 59 second to optimize cpu usage.I dont know how to handle the scenario.
The changes is i want to reduce no. of records per query compared to current one.I might need to put delay
time.The code is error when perform the compiling since im using PRO*c

EXEC SQL EXECUTE 
					BEGIN 
					   INSERT INTO caruser.fwcarrierhistory_hist
								  (sysid, carrierid, carriertype, carrierstate, carrierstatus,
									componentqty, lotid, LOCATION, activity, txntime, txncomment,
									cleancount, usedcount, lastcleandate, grouphistkey, txnkey,
									username)
						  SELECT sysid, carrierid, carriertype, carrierstate, carrierstatus,
								 componentqty, lotid, LOCATION, activity, txntime, txncomment,
								 cleancount, usedcount, lastcleandate, grouphistkey, txnkey,
								 username
							FROM caruser.fwcarrierhistory
						   WHERE sysid = :sysId; 
					   DELETE FROM caruser.fwcarrierhistory
							 WHERE sysid = :sysId;
							 WAITFOR DELAY '00:00:59';
					   INSERT INTO caruser.fwcarrierhistory_pn2m_hist 
								   (fromid, linkname, SEQUENCE, valtype, valdata, keytype,
									keydata)
						  SELECT fromid, linkname, SEQUENCE, valtype, valdata, keytype, keydata
							FROM caruser.fwcarrierhistory_pn2m 
						  WHERE fromid = :sysId; 
					   DELETE FROM caruser.fwcarrierhistory_pn2m 
							 WHERE fromid = :sysId;
							 [B]WAITFOR DELAY '00:00:59';[/B]					   INSERT INTO caruser.fwcarriercomment_hist 
								   (sysid, commentcode, briefdescription, detaildescription)
						  SELECT sysid, commentcode, briefdescription, detaildescription
							FROM caruser.fwcarriercomment 
						  WHERE sysid = :txnComment; 
					    DELETE FROM caruser.fwcarriercomment 
							WHERE sysid = :txnComment;
					    COMMIT;
					END; 
		END-EXEC;

[rski]

To delay use sleep function

exec dbms_lock.sleep(59);