When running this code,
TABLE FILE LOG_TABLE SUM BYTES_SENT BYTES_RECEIVED BY USER_ID WHERE ( LOG_DETAILS.LOG_DETAILS.DATE_TIME GT DT(2010-11-01 12:00:00) ) AND ( LOG_DETAILS.LOG_DETAILS.DATE_TIME LE DT(2010-11-10 23:59:59) ) WHERE READLIMIT EQ 100000 END
I get the following error:
(FOC1400) SQLCODE IS 8115 (HEX: 00001FB3) XOPEN: S0002 : (8115) [S0002] Arithmetic overflow error converting expression to data : type int. (FOC1407) SQL FETCH CURSOR ERROR. : LOG_DETAILS
Does anyone know what causes this?
SeyedThis message has been edited. Last edited by: Kerry,
Date fields are alpha format. You are trying to compare your DATE_TIME field to a numeric. Make sure you only compare alpha to alpha and numeric to numeric.
O/S : Windows
Data Migrator: 7702
Thank you for the reply. I thought that perhaps, summing up the two columns was causing overflow. I am going to work on converting the numeric fields to date and then give it a try.
App Studio 8009
DBMS: Oracle 11g
all output (Excel, HTML, AHTML, PDF)
|Powered by Social Strata|