1 Reply Latest reply: Apr 19, 2013 12:40 AM by 1004080 RSS

    OCI-22053: OVERFLOW Error

    615244
      Hello,

      I am use this Code In .net
      code:
      ===============

      Dim da As New OracleDataAdapter("SELECT STORE, REG_NUM, USER_ID, SALESMAN,(select SUM(NETTOTAL) from REGHEAD) as sales,(select SUM(NETTOTAL) from REGHEAD) - (select SUM(TOTCOST) from REGHEAD) as profit, trunc(mod(((sysdate - sald) * 24),24)) || ':' || trunc(mod(((sysdate - sald) * 1440),60)) || ':' || trunc(mod(((sysdate - sald) * 86400),60)) as Hold_time, ((sysdate - sald) * 86400) as per_Second FROM REGHEAD where DOC_NO = (select Max(DOC_NO) from REGHEAD)", cn)

      da.Fill(dt)
      ==============
      Some time I got data
      & some time I got this error: OCI-22053: OVERFLOW Error
      How I can fix this problem

      thanx
        • 1. Re: OCI-22053: OVERFLOW Error
          1004080
          This is quite a common error with OLD DB. [FIXED: OCI-22053: overflow error|http://www.itjungles.com/other/fixed-oci-22053-overflow-error].

          http://www.itjungles.com/other/fixed-oci-22053-overflow-error

          Edited by: 1001077 on Apr 18, 2013 10:39 PM