How to create Oralce Stored Procedure which drops table and create tables

See more:

SQL

Oracle

I am trying to create Oracle Stored procedure which drops table (if exists) and creates a temp table. Then dumps a data into the temp table

It is giving me complier error:
"Error(12,1): PLS-00103: Encountered the symbol "CREATE""

Can someone please provides some guidance or directions on how to get around this error?

create or replace PROCEDURE SP_GET_USERS(STARTDATE_IN IN DATE, ENDDATE_IN IN DATE)
IS
CANTIDAD integer;
BEGIN

SELECT COUNT(*) INTO CANTIDAD FROM USER_TABLES WHERE TABLE_NAME = TEMP_TABLE1;
IF (CANTIDAD >0) THEN
    execute immediate 'DROP TABLE ' || TEMP_TABLE1
END IF;
--END;

Execute Immediate
'CREATE GLOBAL TEMPORARY TABLE TEMP_TABLE1
        (USER_ID number,
         Role CHAR(30),
		 MONTH_PER CHAR(20),
         COUNT number)
      ON COMMIT DELETE ROWS;'
 END IF;    

INSERT INTO TEMP_TABLE1
(USER_ID, ROLE, MONTH_PER, COUNT) 
SELECT    *
FROM     TABLE1  
WHERE MONTH_PER BETWEEN STARTDATE_IN AND ENDDATE_IN
END;