BPM Advanced 8..1 Question
We have a requirement that involves multiple SQL statements within a single transaction. One of the statements involves an Oracle function call immediately followed by an insert call.
We are able to execute the Oracle function call successfully by using a SQL Call Stored Procedure implementation type. However, this type will not support multiple SQL statements.
Has anyone solved this problem and, if so, provide details of the implementation? We have attempted some of the other implementation types (i.e. SQL Execute Multiple Statements). We are in progress of attempting to implement using SQL Execute Script.
NOTICE: developerWorks Community will be offline May 29-30, 2015 while we upgrade to the latest version of IBM Connections. For more information, read our upgrade FAQ.
This topic has been locked.
1 reply Latest Post - 2013-12-04T15:51:59Z by heyScozzaro
Pinned topic How to execute multiple SQL statements including an Oracle function call
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
heyScozzaro 270004HV0Q54 Posts