This discussion is archived
0 Replies Latest reply: Aug 8, 2012 2:40 PM by 954704 RSS

batching of stored procedures

954704 Newbie
Currently Being Moderated
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!

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points