Home:ALL Converter>Oracle: batch of stored procedures

Oracle: batch of stored procedures

Ask Time:2012-08-09T06:25:17         Author:user1586090

Json Formatter

can I execute a batch of stored procedures via ODBC in Oracle? The stored procedures have input parameters that I 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.

It seems that batching of insert statements is supported in Oracle and also batching of stored procedure is possible if using JDBC.

Is it possible to do same thing but using calls to stored procedures and ODBC?

Thanks

Author:user1586090,eproduced under the CC 4.0 BY-SA copyright license with a link to the original source and this disclaimer.
Link to original article:https://stackoverflow.com/questions/11874104/oracle-batch-of-stored-procedures
yy