存储过程报错:PLS-00201: identifier 'STR_TO_DATE' must be declared
PLS-00201: identifier 'TIME_TO_SEC' must be declared
这是为什么?CREATE OR REPLACE FUNCTION DBF_GETTIMEINTERVALNUM (sDATETIME IN VARCHAR2,nTimespan IN NUMBER)RETURN NUMBER IS
tmpVar NUMBER;
/******************************************************************************
NAME: DBF_GETTIMEINTERVALNUM
PURPOSE: REVISIONS:
Ver Date Author Description
--------- ---------- --------------- ------------------------------------
1.0 2008-9-29 zhuguo 1. Created this function. NOTES: Automatically available Auto Replace Keywords:
Object Name: DBF_GETTIMEINTERVALNUM
Sysdate: 2008-9-29
Date and Time: 2008-9-29, 16:58:18, and 2008-9-29 16:58:18
Username:
Table Name: ******************************************************************************/
nTimeIntervalNum NUMBER;
dDateTime DATE;
BEGIN
if(LENGTH(sDATETIME) <> 14) then
return -1;
end if;
dDateTime := STR_TO_DATE(sDATETIME,'HH24MISS');
nTimeIntervalNum := FLOOR(TIME_TO_SEC(dDateTime)/60/nTimespan);
RETURN nTimeIntervalNum;
EXCEPTION
WHEN NO_DATA_FOUND
THEN
ROLLBACK;
RETURN -1;
WHEN OTHERS
THEN
ROLLBACK;
RETURN -1;
END DBF_GETTIMEINTERVALNUM;
PLS-00201: identifier 'TIME_TO_SEC' must be declared
这是为什么?CREATE OR REPLACE FUNCTION DBF_GETTIMEINTERVALNUM (sDATETIME IN VARCHAR2,nTimespan IN NUMBER)RETURN NUMBER IS
tmpVar NUMBER;
/******************************************************************************
NAME: DBF_GETTIMEINTERVALNUM
PURPOSE: REVISIONS:
Ver Date Author Description
--------- ---------- --------------- ------------------------------------
1.0 2008-9-29 zhuguo 1. Created this function. NOTES: Automatically available Auto Replace Keywords:
Object Name: DBF_GETTIMEINTERVALNUM
Sysdate: 2008-9-29
Date and Time: 2008-9-29, 16:58:18, and 2008-9-29 16:58:18
Username:
Table Name: ******************************************************************************/
nTimeIntervalNum NUMBER;
dDateTime DATE;
BEGIN
if(LENGTH(sDATETIME) <> 14) then
return -1;
end if;
dDateTime := STR_TO_DATE(sDATETIME,'HH24MISS');
nTimeIntervalNum := FLOOR(TIME_TO_SEC(dDateTime)/60/nTimespan);
RETURN nTimeIntervalNum;
EXCEPTION
WHEN NO_DATA_FOUND
THEN
ROLLBACK;
RETURN -1;
WHEN OTHERS
THEN
ROLLBACK;
RETURN -1;
END DBF_GETTIMEINTERVALNUM;
TIME_TO_SEC (time ) //时间转秒数
STR_TO_DATE (string ,format ) //字串转成时间,以format格式显示