Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2006
    Posts
    53

    Unanswered: Confused-intermittent error

    Using Oracle Forms 6i I have a form that compiles cleanly but bombs out most of the time, usually with no error message but sometimes with an ORA-06502.

    The dump when it bombs says ACCESS_VIOLATION and points to a function that loops thru a security table to determine whether or not the user has appropriate rights. The confusing part is that when I inserted message statements to check which record was causing the problem, it ran perfectly.

    So I have 3 situations that seem to occur unpredictably. 1) it bombs (shuts down) without an error message, 2) it stops with an ORA-06502 error, and 3) it runs perfectly. Any guesses as to why it's inconsistent?

    Thanks.
    Now back on Oracle. The more things change, the more they stay the same.

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    data dependent error
    Code:
    06502, 00000, "PL/SQL: numeric or value error%s"
    // *Cause: An arithmetic, numeric, string, conversion, or constraint error
    //         occurred. For example, this error occurs if an attempt is made to
    //         assign the value NULL to a variable declared NOT NULL, or if an
    //         attempt is made to assign an integer larger than 99 to a variable
    //         declared NUMBER(2).   
    // *Action: Change the data, how it is manipulated, or how it is declared so
    //          that values do not violate constraints.
    http://www.orafaq.com/wiki/ORA-06502
    Last edited by anacedent; 10-22-10 at 19:42.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Mar 2006
    Posts
    53
    Yeah, I figured it was data dependent but since it's retrieving the same data every time I can't figure out why it's manifesting in different ways?
    Now back on Oracle. The more things change, the more they stay the same.

Posting Permissions

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