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
2018-07-18, 849👍, 0💬
Popular Posts:
How To Use DATEADD() Function in SQL Server Transact-SQL? DATEADD() is a very useful function for ma...
How To Define an External Table in a Text File in Oracle? You can use the CREATE TABLE statement to ...
How to put statements into a statement block in SQL Server Transact-SQL? You can put statements into...
How to run Queries with SQL Server Management Studio Express in SQL Server? 1. Launch and connect SQ...
Where to find answers to frequently asked questions on Storage Engines: MyISAM, InnoDB and BDB in My...