I am getting error - 'julian date must be between 1 and 5373484' while executing the below given function
function CF_AMOUNT_TO_WORDSFormula return Char is
CURSOR C1 IS
SELECT GH_CURR_CODE
FROM OT_GR_HEAD
WHERE GH_COMP_CODE = :M_COMP_CODE
AND GH_SYS_ID = :P_SYS_ID;
M_CURR_CODE OW_FS.CURR_CODE%TYPE;
M_AMOUNT_TO_WORDS OW_FS.ANNOTATION%TYPE;
begin
IF C1%ISOPEN THEN
CLOSE C1;
END IF;
OPEN C1;
FETCH C1 INTO M_CURR_CODE;
CLOSE C1;
:P_CURR_CODE := NVL(M_CURR_CODE,' ');
P_AMOUNT_TO_WORDS (NVL(:CF_FINAL_NET_VALUE,0), M_CURR_CODE,
:P_LANG_CODE, M_AMOUNT_TO_WORDS);
RETURN INITCAP(NVL(M_AMOUNT_TO_WORDS,' '));
end;
The currency code is DOLLAR.
Please help to solve the problem
Yogesh