在oracle建了个函数,但在plsql中显示有个红叉是怎么回事?
函数:
CREATE OR REPLACE FUNCTION QEBHIS. "GetNl " (csrq in datatime) return int is nl;
begin
nl:= trunc(MONTHS_BETWEEN(sysdate,to_date(csrq, 'yyyy/mm/dd '))/12)
return nl;
end;

调用时说无效的标识符..

还有怎么重命名?

[解决办法]
CREATE OR REPLACE FUNCTION GetNl (csrq in date) return int
is
nl int;
begin
nl:= trunc(MONTHS_BETWEEN(sysdate,to_date(csrq, 'yyyy/mm/dd '))/12);
return nl;
end;