下面的语句为什么有问题?
CREATE PROCEDURE SPGETYEARDATA (
THEYEAR INTEGER)
AS
begin
/* Procedure Text */
select SR_DATE, SR_MONEY, SR_TYPE, SR_INCOMETYPE, SR_PAYOUTTYPE, SR_DESC
from SPENDINGRECORD
where extract(year from SR_DATE)=:THEYEAR;
suspend;
end
如果单独执行其内容的话是没有问题的,不过不知道为什么在添加了参数之后就出现了错误。错误信息如下:
Invalid token.
Dynamic SQL Error.
SQL error code = -104.
Token unknown - line 8, char 44.