求助:存储过程问题
如一个简单的存储过程:
CREATE OR REPLACE PROCEDURE DAP_PROCEDURE11
( AS_YEAR CHAR, AS_MONTH CHAR )
AS
ls_year CHAR(4);
ls_month CHAR(2);
BEGIN
ls_year := AS_YEAR;
ls_month := AS_MONTH;
END
错误提示:
Compilation errors for PROCEDURE PSI.DAP_PROCEDURE11
Error: PLS-00103: 出现符号 ‘”’在需要下列之一时:
( ; is with authid as cluster
compress order using compiled wrapped external deterministic
parallel_enable pipelined
·ûºÅ "" ±»ºöÂÔ¡£
Line: 1
Text: CREATE OR REPLACE PROCEDURE DAP_PROCEDURE11
Error: PLS-00103:出现符号 ‘”’在需要下列之一时:
; is with authid as cluster
order using external deterministic parallel_enable pipelined
Line: 2
Text: ( AS_YEAR CHAR, AS_MONTH CHAR )