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
‹
›
Home
View web version
No comments:
Post a Comment