注册 登录
编程论坛 Oracle论坛

求助:存储过程问题

hawai520 发布于 2006-11-21 15:43, 1803 次点击

如一个简单的存储过程:
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 )

1 回复
#2
人妖1232006-11-29 16:09

( AS_YEAR CHAR, AS_MONTH CHAR ) 有错误
改为:
( AS_YEAR In CHAR(大小), AS_MONTH In CHAR(大小) )

1