Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Julian date error

610101Jan 11 2010 — edited Jan 11 2010
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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 8 2010
Added on Jan 11 2010
9 comments
2,122 views