Skip to Content

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


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!

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Posted on Aug 18, 2004 at 06:25 AM

    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,


    Add comment
    10|10000 characters needed characters exceeded