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, 1587🔥, 0💬
Popular Posts:
How To Turn on mysql Extension on the PHP Engine in MySQL? The "mysql" API extension is provided as ...
How to continue to the next iteration of a WHILE loop in SQL Server Transact-SQL? How to use CONTINU...
What To Do If the StartDB.bat Failed to Start the XE Instance in Oracle? If StartDB.bat failed to st...
Where to find tutorials to answer some frequently asked questions on Microsoft SQL Server Transact-S...
How AdventureWorksLT tables are related in SQL Server? There are 12 user tables defined in Adventure...