Results 1 to 2 of 2

Thread: Number Problems

  1. #1
    Join Date
    Feb 2003

    Question Unanswered: Number Problems

    I have a table that contains a field called Status of type number(4).

    Sometimes, when I do the following:

    UPDATE tablename SET Status =3 WHERE ID=x;

    Status ends up being equal to -9.80E+125 instead of 3.

    I have also experienced this problem with other number fields and values, such as a field of type number(1) being set to 1 or 0 ending up as strange large numbers.

    I am using Oracle9i Enterprise Edition Release running on a Windows 2000 Server.

    Any ideas what is going on?


  2. #2
    Join Date
    Sep 2002
    Provided Answers: 1

    Re: Number Problems

    Sounds like you need to contact Oracle Support on this one!

Posting Permissions

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