1 Reply Latest reply on May 26, 2011 12:27 PM by Sandeep Gandhi, Consultant

    how to convert number to word in R12

    mfa786
      hi

      sir

      i use this
      select to_char( to_date( 85485758, 'j' ), 'Jsp' ) from dual;
      statment for convert number to word but
      this statment give me this error

      ORA-01854: julian date must be between 1 and 5373484
      01854. 00000 - "julian date must be between 1 and 5373484"
      *Cause:    An invalid Julian date was entered.
      *Action:   Enter a valid Julian date between 1 and 5373484.


      please give me idea how i convert number to word


      thank

      fahim