Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2007
    Posts
    4

    Unanswered: Problem-compile form

    HI,

    when i compiled the form i got a list of errors, i think thy're related to the calendar. list of errors are attacched in "pros.bmp"

    Thanx
    Attached Thumbnails Attached Thumbnails pros.bmp  

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1
    You have 2 kinds of error:

    1) Identifier 'DISPLAY_CALENDAR' must be declared.

    This looks like your trigger is calling a procedure DISPLAY_CALENDAR that either doesn't exist, or perhaps is defined in a library that you haven't attached.

    2) too many declarations of 'TO_CHAR' match this call

    This probably means you have applied a TO_CHAR to a value that is already a string. TO_CHAR can be called for dates or numbers, so it tries to helpfully coerce your string into something appropriate but doesn't know which version you want - date or number. You may not need the TO_CHAR call at all, or if you do you may need to explicitly convert the argument first like this:

    TO_CHAR( TO_NUMBER(:input), '999.99')
    TO_CHAR( TO_DATE(:input, 'DD-MON-YYYY' /* current format */), 'YYYY-MM-DD' /* desired format */)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •