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