ORA-01008 (not all variables bound) during INSERT - Oracle

[Former Member]

Hi!

I have some programs which inserts data in Oracle database tables using EXEC SQL. This normally works ok but sometimes the programs are cancelled (with short dump) by an ORA-1008 error, which says "not all variables bound".

Debugging the code I can notice that all the variables are filled before the insert command so why it doesn't work? Another point is that the same collections of data that generates the error is inserted normally later in one of the subsequent executions (!?!).

Have someone experienced this? How can I solve this issue?

Thanks to all!

[VXLozano]

Humm... I'm not sure if it will be what I think, because I have no access to my DBMS, but the guy who teached me all I know about SAP (and not learnt in this forum) said me the logical tables in SAP some times are not equal to the phisical ones in the DBMS.

If you have access to your DBMS and could launch a query directly to it, maybe you could test if your SQL sentence works there.

From I could understand, the application server and the data server of SAP make some conversions to keep the integrity of the DB and changing some (non exec) SQL to fit in this different "layout".

I wish it helps,

Vicenç