Skip to Content
0
Former Member
Dec 12, 2006 at 05:12 AM

Integer datatype with length > 10

4230 Views

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