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.
heyScozzaro 270004HV0Q54 Posts
Re: How to execute multiple SQL statements including an Oracle function call2013-12-04T15:51:59ZThis is the accepted answer. This is the accepted answer.
Hi, did you ever manage to solve your problem? If so, would you mind describing a solution? i am up to a similar task.