Collections:
Pass a Cursor Variable to a Procedure in Oracle
How To Pass a Cursor Variable to a Procedure in Oracle?
✍: FYIcenter.com
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 Higgins
⇒ Cursor Variable Easier to Use than Cursor in Oracle
⇐ Loop through a Cursor Variable in Oracle
2018-07-18, 1604🔥, 0💬
Popular Posts:
What Happens If the UPDATE Subquery Returns Multiple Rows in SQL Server? If a subquery is used in a ...
How To Convert a Unicode Strings to Non-Unicode Strings in SQL Server Transact-SQL? Since Unicode ch...
How To Find Out What Privileges a User Currently Has in Oracle? Privileges granted to users are list...
What Happens to Your Transactions When ERROR 1213 Occurred in MySQL? If your transaction receives th...
What Is the Difference Between GETDATE() and GETUTCDATE() in SQL Server Transact-SQL? The difference...