日期:2014-05-17  浏览次数:22147 次

在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;