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, 2088🔥, 0💬
Popular Posts:
How To End a Stored Procedure Properly in SQL Server Transact-SQL? Where the end of the "CREATE PROC...
How To Use "IF ... ELSE IF ..." Statement Structures in SQL Server Transact-SQL? "IF ... ELSE IF ......
Can Date and Time Values Be Converted into Integers in SQL Server Transact-SQL? Can date and time va...
How To Use DATEADD() Function in SQL Server Transact-SQL? DATEADD() is a very useful function for ma...
How to connect SQL Server Management Studio Express to SQL Server 2005 Express in SQL Server? Once y...