CREATE OR REPLACE PROCEDURE test
IS
  CURSOR cusers IS SELECT user_name, user_date FROM users;
  uname users.user_name%TYPE;
  udate users.user_date%TYPE;
BEGIN
  OPEN cusers;
  LOOP
     FETCH cusers INTO uname, udate;
     EXIT WHEN cusers%NOTFOUND;
     DBMS_OUTPUT.PUT_LINE('name: ' || uname || ' date: ' || udate);
  END LOOP;
  CLOSE cusers;
END;

ORA-00900: invalid SQL statement

CREATE TABLE  "USERS" 
   (	"USER_ID" NUMBER(10,0) NOT NULL ENABLE, 
	"USER_NAME" VARCHAR2(50) NOT NULL ENABLE, 
	"USER_EMAIL" VARCHAR2(50) NOT NULL ENABLE, 
	"USER_PASS" VARCHAR2(50) NOT NULL ENABLE, 
	"USER_DATE" DATE NOT NULL ENABLE, 
	 CONSTRAINT "USERS_PK" PRIMARY KEY ("USER_ID") ENABLE
   )

SQL> CREATE TABLE  "USERS" 
  2     ( "USER_ID" NUMBER(10,0) NOT NULL ENABLE, 
  3   "USER_NAME" VARCHAR2(50) NOT NULL ENABLE, 
  4   "USER_EMAIL" VARCHAR2(50) NOT NULL ENABLE, 
  5   "USER_PASS" VARCHAR2(50) NOT NULL ENABLE, 
  6   "USER_DATE" DATE NOT NULL ENABLE, 
  7    CONSTRAINT "USERS_PK" PRIMARY KEY ("USER_ID") ENABLE
  8     )
  9  
SQL> 
SQL> /

Table created.

SQL> CREATE OR REPLACE PROCEDURE test
  2  IS
  3    CURSOR cusers IS SELECT user_name, user_date FROM users;
  4    uname users.user_name%TYPE;
  5    udate users.user_date%TYPE;
  6  BEGIN
  7    OPEN cusers;
  8    LOOP
  9       FETCH cusers INTO uname, udate;
 10       EXIT WHEN cusers%NOTFOUND;
 11       DBMS_OUTPUT.PUT_LINE('name: ' || uname || ' date: ' || udate);
 12    END LOOP;
 13    CLOSE cusers;
 14  END;
 15  
 16  /

Procedure created.

SQL> exec test;

PL/SQL procedure successfully completed.