Skip to Main Content
Forums

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

OCI-22053: OVERFLOW Error

615244Mar 29 2008 — edited Apr 19 2013
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
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
1 - 1
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on May 17 2013
Added on Mar 29 2008
#oracle-provider-for-ole-db, #windows-and-net
1 comment
13,525 views