OBIEE writeback xml files (one with PL/SQL merge, another with execute, therefore it is available to call those statements for OBI WB)

obiee_writeback_execute.xml

<?xml version="1.0" encoding="utf-8" ?>
<WebMessageTables xmlns:sawm="com.siebel.analytics.web/message/v1">
	<WebMessageTable lang="en-us" system="WriteBack" table="Messages">
		<WebMessage name="testExecute">
			<XML>
				<writeBack connectionPool="cp_logistics_write_back">
					<insert> </insert>
					<update> call execute_test() </update>
				</writeBack>
			</XML>
		</WebMessage>
	</WebMessageTable>
</WebMessageTables>

obiee_writeback_merge.xml

<?xml version="1.0" encoding="utf-8" ?>
<WebMessageTables xmlns:sawm="com.siebel.analytics.web/message/v1">
	<WebMessageTable lang="en-us" system="WriteBack" table="Messages">
		<WebMessage name="testWriteBack">
			<XML>
				<writeBack connectionPool="cp_test_writeback">
					<insert> </insert>
					<update> MERGE INTO LOGISTICS.SRC_TABLE USING (
							  SELECT
								@{idrref} AS IDRREF,
								'@{name}' AS NAME
							  FROM
								DUAL
							) T
							ON (SRC_TABLE.IDRREF = T.IDRREF)
							WHEN MATCHED THEN
							  UPDATE
								SET
								  SRC_TABLE.NAME = T.NAME
							WHEN NOT MATCHED THEN
							  INSERT (
								SRC_TABLE.ID,
								SRC_TABLE.IDRREF,
								SRC_TABLE.NAME
							  )
							  VALUES (
								LOGISTICS.SEQ_QA_ISSUE_LOG.NEXTVAL,
								T.IDRREF,
								T.NAME
							  );
					</update>
				</writeBack>
			</XML>
		</WebMessage>
	</WebMessageTable>
</WebMessageTables>