DECLARE
    TYPE AUTHOR_CUR IS REF CURSOR;
    C1 AUTHOR_CUR;
    R_C1 VARCHAR2(50);
    QRY VARCHAR2(50);
BEGIN
    QRY := 'SELECT DISTINCT Abc FROM table';
    OPEN C1 FOR QRY;
    FETCH C1 INTO R_C1;
        IF C1%ISOPEN THEN
            DBMS_OUTPUT.PUT_LINE('CURSOR OPEN');
            END IF;
            DBMS_OUTPUT.PUT_LINE(C1%ROWCOUNT);
    CLOSE C1;    
END;