oracle的存储过程问题，下面是存储过程语句，执行时报ORA-00922：选项缺失或无效

CREATE OR REPLACe "GETATTENDANCEDATA" is
P_ENT varchar(6);
P_SQL VARCHAr(100000) := 'UNIOn ';
VS_STMT VARCHAr(100);

BEGIN
FOR P_ENT IN (SELECT ENTID FROM A_AC_ENTAUDIT WHERe AUDITRESULT='1')
LOOP
IF P_ENT.ENTID IS NOT NULL THEN
VS_STMT := 'SELECt TR_DATE,ENTERPRISE FROM B_CHECKIN_'||P_ENT||'
UNIOn
SELECt TR_DATE,ENTERPRISE FROM B_CHECKIN_HIS_'||P_ENT;
P_SQL := P_SQL + VS_STMT;
END IF;
END LOOP;
dbms_output.put_line('SQL语句 ：'||to_char(P_SQL));
END;

没有关键字procedure 将CREATE OR REPLACE "GETATTENDANCEDATA" is修改为CREATE OR REPLACE procedure "GETATTENDANCEDATA" is

缺了关键字PROCEDURE. CREATE OR REPLACE PROCEDURE ......

你好！ 缺了关键字PROCEDURE. CREATE OR REPLACE PROCEDURE ...... 仅代表个人观点，不喜勿喷，谢谢。