Oracle data USES cursors

create or replace 
PROCEDURE proceudre_name AS 
BEGIN 
DECLARE 
sPara VARCHAR(50); 
sPara2 VARCHAR(50); 
CURSOR c_cursor IS SELECT ID,Name FROM Temp_table; 
BEGIN 
OPEN c_cursor; 
LOOP 
FETCH c_cursor INTO sPara, sPara2; 
EXIT WHEN c_cursor%NOTFOUND; 
BEGIN 
--just do what you want. 
END; 
END LOOP; 
CLOSE c_cursor; 
END; 
END;