KB485154: Oracle PL/SQL Syntax for Multiple Statements and Procedure Execution in a Single Parameterized Transaction

Execute Multiple Statements Using PL/SQL With Strategy Parameterized Transaction

Transaction FFSQL Report Configuration

Strategy SQL Generation
SQL Statements:
BEGIN
INSERT INTO PQTX_CUSTOMER
(CUSTOMER_ID, CUST_LAST_NAME)
values (?, ?);
INSERT INTO PQTX_DATATYPES
(DATE_TYPE)
values (?);
END;
 

Execute Oracle Procedures Using PL/SQL With Strategy Parameterized Transaction

Transaction FFSQL Report Configuration

Strategy SQL Generation
SQL Statements:
DECLARE
city_id NUMBER(5,0) := ?;
city_desc NVARCHAR2(50) := ?;
BEGIN
AddToCityList(city_id, city_desc);
END;