Hello,
The issue I presently face is that in one of the database tables contains an integer field of type INT4 (length 10). The data coming into this field has integer values > 10. Due to this the data stored in the table is corrupt with incorrect delimiters.
When a SELECT is performed, the dump DBIF_RSQL_SQL_ERROR
is faced.
With analysis, it is found that :
"To be more exact, ORA-01455 means that in the context of a SELECT
statement, you try to transfer the content of a column to an integer
variable whereupon the content of the column disrupts the integer number
area."
Apart from changing the datatype to a one that contains length > 10, is there any other way to address this issue.
Regards
Anupama