2 Replies Latest reply on Jan 9, 2018 8:03 PM by rp0428

    Incorrect Data in a Decimal(28,7) field

    user5163535

      Hi,

       

      We have several fields defined as 28,7.  However, for some reason our monitors are storing some data that is not decimal(28,7) and is instead, much larger.

      We can see the information in the database, however when we try to extract it, Oracle errors and says the data is not decimal(28,7).

       

      Obviously, the best way to fix this is in the application (they won't).

       

      Has anyone else run into a problem like this?

       

      I'm wondering if the DB is corrupt.

       

      Thanks!

      Scott Unrein

        • 1. Re: Incorrect Data in a Decimal(28,7) field
          EdStevens

          user5163535 wrote:

           

          Hi,

           

          We have several fields defined as 28,7. However, for some reason our monitors are storing some data that is not decimal(28,7) and is instead, much larger.

          We can see the information in the database, however when we try to extract it, Oracle errors and says the data is not decimal(28,7).

           

          Obviously, the best way to fix this is in the application (they won't).

           

          Has anyone else run into a problem like this?

           

          I'm wondering if the DB is corrupt.

           

          Thanks!

          Scott Unrein

          Show a 'describe <tablename>'

          Show a select statement that reveals the bad data.

          • 2. Re: Incorrect Data in a Decimal(28,7) field

            Wrong forum.

             

            This forum is ONLY for Sql Developer questions/issues.

             

            Please move the thread to the general database forum

            General Database Discussions

            We have several fields defined as 28,7. However, for some reason our monitors are storing some data that is not decimal(28,7) and is instead, much larger.

            We can see the information in the database, however when we try to extract it, Oracle errors and says the data is not decimal(28,7).

            Before you move the thread be prepared to explain the following

             

            1. Oracle does NOT have 'fields' - it has colulmns

            2. monitors do NOT store data

            3. how do you 'see the information in the database'? How can you see it if you can't 'extract it'?

            4. show the results of using the DUMP function on the column

            select myColumn, dump (myColumn) from myTable where rownum = 1