Topic
IC4NOTICE: 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.
1 reply Latest Post - ‏2013-12-04T15:51:59Z by heyScozzaro
J9V5_Diane_Strachan
J9V5_Diane_Strachan
1 Post
ACCEPTED ANSWER

Pinned topic How to execute multiple SQL statements including an Oracle function call

‏2013-02-04T16:41:49Z |
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
    heyScozzaro
    54 Posts
    ACCEPTED ANSWER

    Re: How to execute multiple SQL statements including an Oracle function call

    ‏2013-12-04T15:51:59Z  in response to J9V5_Diane_Strachan

    Hi, did you ever manage to solve your problem? If so, would you mind describing a solution? i am up to a similar task.

    Thank you.