Results 1 to 3 of 3

Thread: forms

  1. #1
    Join Date
    Nov 2010

    Unanswered: forms

    I am using oracle forms6i.
    i am getting the error
    "ORA-01483: invalid length for DATE or NUMBER bind variable"
    But i have not changed the length of any variable.
    i have checked the help->display error option too.
    i got the error message mentioned as above.
    can you please help me

  2. #2
    Join Date
    Jan 2004
    Croatia, Europe
    Provided Answers: 4
    Oracle suggests that it is too long:
    Quote Originally Posted by Oracle
    ORA-01483: invalid length for DATE or NUMBER bind variable

    Cause: A bind variable of type DATE or NUMBER is too long.

    Action: Consult your manual for the maximum allowable length
    You'll need to debug the form. Unfortunately, 6i doesn't offer running a form in debug mode (such as 10g), so you'll have to put MESSAGE built-ins into triggers so that you'd know which one failed (unless you already know it) and trace its execution step by step. Display current values (using MESSAGE once again) and, hopefully, you'll find the culprit.

  3. #3
    Join Date
    Nov 2010


    ok i ll try that one .

Tags for this Thread

Posting Permissions

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