InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
How To Pass A Cursor Variable To A Procedure? |
|
Answer» A cursor variable can be passed into a procedure like a NORMAL variable. The sample script below gives you a good example: CREATE OR REPLACE PROCEDURE FYI_CENTER AS sys_cur SYS_REFCURSOR; PROCEDURE emp_print(cur SYS_REFCURSOR) AS emp_rec employees%ROWTYPE; BEGIN LOOP FETCH cur INTO emp_rec; EXIT WHEN cur%NOTFOUND; DBMS_OUTPUT.PUT_LINE('Name = ' || emp_rec.first_name || ' ' || emp_rec.last_name); END LOOP; END; BEGIN OPEN sys_cur FOR SELECT * FROM employees WHERE manager_id = 101; emp_print(sys_cur); CLOSE sys_cur; END; / Name = NANCY Greenberg Name = Jennifer Whalen Name = Susan Mavris Name = Hermann BAER Name = Shelley HigginsA cursor variable can be passed into a procedure like a normal variable. The sample script below gives you a good example: |
|