Oracle Job will not run

Hi,

Could someone please tell me why this procedure will not run as a scheduled job? I am running it as GISDBA (full DBA privileges).

create or replace
PROCEDURE correct_hansen_streets AUTHID CURRENT_USER is

BEGIN
  EXECUTE IMMEDIATE 'DROP TABLE PRISM.TMP_1';
  EXECUTE IMMEDIATE 'CREATE TABLE PRISM.tmp_1 AS SELECT a.id, b.column_value FROM GISDBA.asset_hansen_centreline a, TABLE(a.geometry1.sdo_elem_info) b';
  EXECUTE IMMEDIATE 'DROP TABLE PRISM.hansencorrectrecords';
  EXECUTE IMMEDIATE 'CREATE TABLE PRISM.hansencorrectrecords AS SELECT id,count(*) "CNT" FROM PRISM.tmp_1 GROUP BY id';
  EXECUTE IMMEDIATE 'DELETE FROM PRISM.hansencorrectrecords WHERE cnt>3';