Forum Stats

  • 3,784,354 Users
  • 2,254,928 Discussions
  • 7,880,790 Comments

Discussions

OCI-22053: OVERFLOW Error

615244
615244 Member Posts: 2
edited Apr 19, 2013 1:40AM in Oracle Provider for OLE DB
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

Comments

  • 1004080
    1004080 Member Posts: 1
    edited Apr 19, 2013 1:40AM
    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
This discussion has been closed.