0 Replies Latest reply on Aug 9, 2012 7:41 AM by 954704

    batching of stored procedures via ODBC

      Hi all,
      I've a good experience with DB2 and SQL Server, but I'm new to Oracle.

      Now I'm porting my ODBC application written in C++ to Oracle and I'd like to know if with Oracle I can execute a batch of stored procedures via ODBC.
      The stored procedures have input parameters that we bind using parameter markers.

      In SQL Server I have this capability, in DB2 I just have the possibility to do batch inserts/updates but I cannot batch stored procedures from ODBC/C++ code.

      From my first Internet search I found that batching of insert statements is supported in Oracle.
      Is it possible to do same thing but using calls to stored procedures instead of insert statements?

      Thank you very much for your help!