abcd
Saturday, May 25, 2013
closing cursor in plsql
CREATE PROCEDURE close_cursor (v_count OUT INTEGER)
AS
CURSOR c1
IS
SELECT COUNT (*)
FROM all_users;
BEGIN
v_count := 0;
OPEN c1;
FETCH c1
INTO v_count;
CLOSE c1
END;
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment