SQL Error -302 while inserting into database table

[former_member186608]

Dear community,

not sure if my concern is located correctly here, however I would like to have your comments on the following issue I am encountering on a SAP system.

The system is running on a DB6 database.

I have a database table and I want to insert a new tuple there. The work area used in the open SQL insert statement is typed as the database table. Hence from a data type perspective, the runtime environment should take care that all values in the work area correspond accordingly to the schema of the database table.

However, I am receiving a short dump stating the following:

sql error -302   performing INS on table DATABASE_TABLE_NAME               [dbtrtab#3770]

SQL0302N  The value of a host variable in the EXECUTE or OPEN statement is out of range for its corresponding use.  SQLSTATE=22003 row=1 [dbtrtab#3770]

I have investigated in the debugger whether this is a corrupt value or something similar, but was not able to find any suspicious field.

I have no clue how to proceed. Is there any possibility to examine which component of the work area causes the issue?

Thanks in advance and looking forward to a discussion with you all,

Marco

[marcus_schug1]

Dear Marco,

I have the same problem with DEC3_7 I have a function which returns the value of TB_YIELD but the value could be greater than 999.9999999 and if I store to datebase I got the same error.

Have you found a solution?

Regards

MArcus