Unclosed Implicit cursor

[gandolf989]

Since you are only selecting COUNT(*) you should not do a cursor. You certainly should not try to do both. Just use the SELECT INTO statement.

IS
   SELECT count(*)
     INTO v_count
     FROM table_A;
END;
/