Skip to content

/ oracle-mda-utility

generated from blue-prism/repo-template
Permalink
master

oracle-mda-utility/OracleMDA_5.bprelease

Go to file
@EricWilson-BluePrism
EricWilson-BluePrism v5 - Studio Display Fix
Latest commit 0c1e3cf Jan 4, 2021 History 
Ran bprelease through the Studio Display Fix utility.
1 contributor

Users who have contributed to this file

4698 lines (4670 sloc) 219 KB
Raw Blame
<?xml version="1.0" encoding="utf-8"?>
<bpr:release xmlns:bpr="http://www.blueprism.co.uk/product/release">
<bpr:name>OracleMDA_4</bpr:name>
<bpr:release-notes>Addressed issue highlighted by Nupur Sood. The internal close wasn't closing properly unless clearpool was set and even then it wasn't working correctly.
New code is translation of the code used for the SQL Server equivalent.</bpr:release-notes>
<bpr:created>2021-01-04 12:42:05Z</bpr:created>
<bpr:package-id>20</bpr:package-id>
<bpr:package-name>Blue Prism - Oracle MDA</bpr:package-name>
<bpr:user-created-by>admin</bpr:user-created-by>
<bpr:contents count="9">
<process id="a900623b-8d3d-4dbe-9183-61ad2a919fdc" name="Blue Prism - Oracle MDA Test" xmlns="http://www.blueprism.co.uk/product/process">
<process name="Blue Prism - Oracle MDA Test" version="1.0" bpversion="6.9.0.26970" narrative="" byrefcollection="true">
<view>
<camerax>-203</camerax>
<cameray>124</cameray>
<zoom version="2">1.25</zoom>
</view>
<preconditions />
<endpoint narrative="" />
<subsheet subsheetid="40b71b60-2c56-4235-9d5d-482a0f568d00" type="Normal" published="False">
<name>DROP TABLE</name>
<view>
<camerax>-8</camerax>
<cameray>0</cameray>
<zoom version="2">1.25</zoom>
</view>
</subsheet>
<subsheet subsheetid="e72a8467-73cd-4ae4-9eba-a8950f47f49f" type="Normal" published="False">
<name>DELETE ROWS</name>
<view>
<camerax>-8</camerax>
<cameray>0</cameray>
<zoom version="2">1.25</zoom>
</view>
</subsheet>
<subsheet subsheetid="607b66af-d5eb-4234-850f-6dc9ded407c3" type="Normal" published="False">
<name>TRUNCATE TABLE</name>
<view>
<camerax>-8</camerax>
<cameray>0</cameray>
<zoom version="2">1.25</zoom>
</view>
</subsheet>
<subsheet subsheetid="1a7f8351-c5c0-4486-b1be-7edaa9b3b888" type="Normal" published="False">
<name>Get Machine Name</name>
<view>
<camerax>0</camerax>
<cameray>0</cameray>
<zoom version="2">1.25</zoom>
</view>
</subsheet>
<subsheet subsheetid="fbee9ab3-c882-4b15-93b3-7b51b3b60772" type="Normal" published="False">
<name>Get User Name</name>
<view>
<camerax>0</camerax>
<cameray>0</cameray>
<zoom version="2">1.25</zoom>
</view>
</subsheet>
<subsheet subsheetid="e51225a7-9878-4669-aa28-7b96c3892373" type="Normal" published="False">
<name>Get CSV </name>
<view>
<camerax>-63</camerax>
<cameray>0</cameray>
<zoom version="2">1.25</zoom>
</view>
</subsheet>
<subsheet subsheetid="1d6d6457-faf8-4638-8009-7e1399aa73b0" type="Normal" published="False">
<name>Get CSV File</name>
<view>
<camerax>0</camerax>
<cameray>0</cameray>
<zoom version="2">1.25</zoom>
</view>
</subsheet>
<subsheet subsheetid="b7fd8cc2-f883-437e-8560-fb8d0c6c2c66" type="Normal" published="False">
<name>Transaction - Commit</name>
<view>
<camerax>-38</camerax>
<cameray>-1</cameray>
<zoom version="2">1.25</zoom>
</view>
</subsheet>
<subsheet subsheetid="00bad46a-aff4-4971-970b-01b796172688" type="Normal" published="False">
<name>Get Collection</name>
<view>
<camerax>0</camerax>
<cameray>0</cameray>
<zoom version="2">1.25</zoom>
</view>
</subsheet>
<stage stageid="b0395fe2-3a08-42c8-a792-107ba4dddf65" name="Start" type="Start">
<onsuccess>8269a258-d7bb-4a6b-8557-b01c76fec6cf</onsuccess>
<displayx>15</displayx>
<displayy>-150</displayy>
</stage>
<stage stageid="8269a258-d7bb-4a6b-8557-b01c76fec6cf" name="End" type="End">
<displayx>15</displayx>
<displayy>120</displayy>
</stage>
<stage stageid="edaff19f-758e-4056-ab04-1774177540f9" name="Stage1" type="ProcessInfo">
<displayx>-195</displayx>
<displayy>-105</displayy>
<displaywidth>150</displaywidth>
<displayheight>90</displayheight>
</stage>
<stage stageid="386d6a8c-bf49-4017-a6b7-38b2222fd2c7" name="Blue Prism - OracleMDA_Host" type="Data">
<datatype>text</datatype>
<initialvalue />
<exposure>Environment</exposure>
<alwaysinit />
<displayx>-195</displayx>
<displayy>-15</displayy>
<displaywidth>180</displaywidth>
<displayheight>30</displayheight>
</stage>
<stage stageid="2771adee-a1e1-47b8-82e9-f2d2eacc8d91" name="Blue Prism - OracleMDA_Port" type="Data">
<datatype>text</datatype>
<initialvalue />
<exposure>Environment</exposure>
<alwaysinit />
<displayx>-195</displayx>
<displayy>30</displayy>
<displaywidth>180</displaywidth>
<displayheight>30</displayheight>
</stage>
<stage stageid="17aee7ac-806b-4292-8020-0b38f7e1a220" name="Blue Prism - OracleMDA_SID" type="Data">
<datatype>text</datatype>
<initialvalue />
<exposure>Environment</exposure>
<alwaysinit />
<displayx>-195</displayx>
<displayy>75</displayy>
<displaywidth>180</displaywidth>
<displayheight>30</displayheight>
</stage>
<stage stageid="b6d87639-641a-45d5-8cf3-fc83826afeab" name="Blue Prism - OracleMDA_User" type="Data">
<datatype>text</datatype>
<initialvalue />
<exposure>Environment</exposure>
<alwaysinit />
<displayx>-195</displayx>
<displayy>120</displayy>
<displaywidth>180</displaywidth>
<displayheight>30</displayheight>
</stage>
<stage stageid="b5836782-afd0-493b-8729-3e3532fa4319" name="Blue Prism - OracleMDA_Password" type="Data">
<datatype>password</datatype>
<initialvalueenc></initialvalueenc>
<exposure>Environment</exposure>
<alwaysinit />
<displayx>-195</displayx>
<displayy>165</displayy>
<displaywidth>180</displaywidth>
<displayheight>30</displayheight>
</stage>
<stage stageid="f5dffc26-3412-4eac-9c36-6986333af96e" name="ConnStr" type="Data">
<datatype>text</datatype>
<initialvalue />
<alwaysinit />
<displayx>-195</displayx>
<displayy>210</displayy>
</stage>
<stage stageid="4105c393-6f62-44d1-a0e6-650ec1e423fd" name="DROP TABLE" type="SubSheetInfo">
<subsheetid>40b71b60-2c56-4235-9d5d-482a0f568d00</subsheetid>
<narrative>The data item TableToDrop contains the name of the table to be removed from the database. The ReportExceptions value is a flag if you wish to have any exceptions detailed. Finally, Message and Success are details of the outcome.</narrative>
<displayx>-195</displayx>
<displayy>-105</displayy>
<displaywidth>150</displaywidth>
<displayheight>90</displayheight>
</stage>
<stage stageid="a0ca58a0-4d02-49e6-a0fd-877cd23315c0" name="Start" type="Start">
<subsheetid>40b71b60-2c56-4235-9d5d-482a0f568d00</subsheetid>
<onsuccess>79bec70c-b644-4c06-accb-dd06db46fb3c</onsuccess>
<displayx>15</displayx>
<displayy>-105</displayy>
</stage>
<stage stageid="92a5a17e-886b-456b-a086-dd8cd6317b68" name="End" type="End">
<subsheetid>40b71b60-2c56-4235-9d5d-482a0f568d00</subsheetid>
<displayx>15</displayx>
<displayy>90</displayy>
</stage>
<stage stageid="d1b1cbd3-b664-4a44-9278-eafa441ebbd1" name="Data - Oracle (MDA)::Drop Table" type="Action">
<subsheetid>40b71b60-2c56-4235-9d5d-482a0f568d00</subsheetid>
<loginhibit onsuccess="true" />
<inputs>
<input type="text" name="TableToDrop" friendlyname="TableToDrop" expr="[TableToDrop]" />
<input type="flag" name="ReportExceptions" friendlyname="ReportExceptions" expr="[ReportExceptions]" />
</inputs>
<outputs>
<output type="flag" name="Success" friendlyname="Success" stage="Success" />
<output type="text" name="Message" friendlyname="Message" stage="Message" />
</outputs>
<onsuccess>92a5a17e-886b-456b-a086-dd8cd6317b68</onsuccess>
<resource object="Data - Oracle (MDA)" action="Drop Table" />
<displayx>15</displayx>
<displayy>15</displayy>
</stage>
<stage stageid="12b306d1-049f-4df1-9612-47dbe1a54336" name="Success" type="Data">
<subsheetid>40b71b60-2c56-4235-9d5d-482a0f568d00</subsheetid>
<datatype>flag</datatype>
<initialvalue />
<private />
<alwaysinit />
<displayx>-135</displayx>
<displayy>120</displayy>
</stage>
<stage stageid="2c3947d4-1ed6-40a4-8508-16ed1a07eee8" name="Message" type="Data">
<subsheetid>40b71b60-2c56-4235-9d5d-482a0f568d00</subsheetid>
<datatype>text</datatype>
<initialvalue />
<private />
<alwaysinit />
<displayx>-210</displayx>
<displayy>120</displayy>
<displaywidth>90</displaywidth>
<displayheight>30</displayheight>
</stage>
<stage stageid="79bec70c-b644-4c06-accb-dd06db46fb3c" name="Data - Oracle (MDA)::Set Connection" type="Action">
<subsheetid>40b71b60-2c56-4235-9d5d-482a0f568d00</subsheetid>
<loginhibit onsuccess="true" />
<inputs>
<input type="text" name="ConnectionName" friendlyname="ConnectionName" expr="[Blue Prism - OracleMDA_SID]" />
<input type="text" name="Hostname" friendlyname="Hostname" narrative="The IP address of the oracle host." expr="[Blue Prism - OracleMDA_Port]" />
<input type="text" name="Port" friendlyname="Port" narrative="The listening port on the oracle host." expr="[Blue Prism - OracleMDA_Port]" />
<input type="text" name="Username" friendlyname="Username" expr="[Blue Prism - OracleMDA_User]" />
<input type="password" name="Password" friendlyname="Password" expr="[Blue Prism - OracleMDA_Password]" />
</inputs>
<outputs>
<output type="text" name="ConnectionString" friendlyname="ConnectionString" stage="ConnStr" />
</outputs>
<onsuccess>d1b1cbd3-b664-4a44-9278-eafa441ebbd1</onsuccess>
<resource object="Data - Oracle (MDA)" action="Set Connection" />
<displayx>15</displayx>
<displayy>-45</displayy>
<displaywidth>120</displaywidth>
<displayheight>30</displayheight>
</stage>
<stage stageid="01999abd-55d9-4178-b565-bbb4c1b46a6a" name="TableToDrop" type="Data">
<subsheetid>40b71b60-2c56-4235-9d5d-482a0f568d00</subsheetid>
<datatype>text</datatype>
<initialvalue />
<private />
<alwaysinit />
<displayx>-180</displayx>
<displayy>-15</displayy>
<displaywidth>90</displaywidth>
<displayheight>30</displayheight>
</stage>
<stage stageid="8f3212bd-d546-4f92-bacf-85e256f8a641" name="ReportExceptions" type="Data">
<subsheetid>40b71b60-2c56-4235-9d5d-482a0f568d00</subsheetid>
<datatype>flag</datatype>
<initialvalue>False</initialvalue>
<private />
<alwaysinit />
<displayx>-180</displayx>
<displayy>30</displayy>
<displaywidth>120</displaywidth>
<displayheight>30</displayheight>
</stage>
<stage stageid="15fe1992-51c5-492a-9cc1-65bc92cbe7c4" name="DELETE ROWS" type="SubSheetInfo">
<subsheetid>e72a8467-73cd-4ae4-9eba-a8950f47f49f</subsheetid>
<narrative>The data items TableToDeleteFrom is the name of the table that rows are to be removed from. There is a WhereClause that will limit the power of the delete so that it becomes more difficult to indadvertently delete a whole set of table data. ReportExceptions is a flag to permit the feedback of exception data. Message and Success will detail the outcome of the process. This action makes use of the Set Connection action in order to assume communication with the Oracle Database.</narrative>
<displayx>-195</displayx>
<displayy>-105</displayy>
<displaywidth>270</displaywidth>
<displayheight>90</displayheight>
</stage>
<stage stageid="efc9c755-0e72-426b-837b-ce71e0990894" name="Start" type="Start">
<subsheetid>e72a8467-73cd-4ae4-9eba-a8950f47f49f</subsheetid>
<onsuccess>735ec94e-5ceb-4c8b-989a-d64229b22ddf</onsuccess>
<displayx>30</displayx>
<displayy>-90</displayy>
</stage>
<stage stageid="a955c6ad-3d3a-495f-8d3c-c8ad981f54bb" name="End" type="End">
<subsheetid>e72a8467-73cd-4ae4-9eba-a8950f47f49f</subsheetid>
<displayx>30</displayx>
<displayy>105</displayy>
</stage>
<stage stageid="53afebf6-06fd-4f53-a6d5-03d95e3d18e7" name="Data - Oracle (MDA)::Delete Rows - Where" type="Action">
<subsheetid>e72a8467-73cd-4ae4-9eba-a8950f47f49f</subsheetid>
<loginhibit onsuccess="true" />
<inputs>
<input type="text" name="TableToDeleteFrom" friendlyname="TableToDeleteFrom" expr="[TableToDeleteFrom]" />
<input type="text" name="WhereClause" friendlyname="WhereClause" expr="[WhereClause]" />
</inputs>
<outputs>
<output type="flag" name="Success" friendlyname="Success" stage="Success" />
<output type="text" name="Message" friendlyname="Message" stage="Message" />
</outputs>
<onsuccess>a955c6ad-3d3a-495f-8d3c-c8ad981f54bb</onsuccess>
<resource object="Data - Oracle (MDA)" action="Delete Rows - Where" />
<displayx>30</displayx>
<displayy>30</displayy>
<displaywidth>120</displaywidth>
<displayheight>30</displayheight>
</stage>
<stage stageid="fa2045e9-e3bc-4f36-91ee-b94df8ba4bf9" name="Success" type="Data">
<subsheetid>e72a8467-73cd-4ae4-9eba-a8950f47f49f</subsheetid>
<datatype>flag</datatype>
<initialvalue />
<private />
<alwaysinit />
<displayx>-180</displayx>
<displayy>105</displayy>
</stage>
<stage stageid="7e2a1169-93fc-444d-a205-1a92ad492c18" name="Message" type="Data">
<subsheetid>e72a8467-73cd-4ae4-9eba-a8950f47f49f</subsheetid>
<datatype>text</datatype>
<initialvalue />
<private />
<alwaysinit />
<displayx>-255</displayx>
<displayy>105</displayy>
<displaywidth>90</displaywidth>
<displayheight>30</displayheight>
</stage>
<stage stageid="735ec94e-5ceb-4c8b-989a-d64229b22ddf" name="Data - Oracle (MDA)::Set Connection" type="Action">
<subsheetid>e72a8467-73cd-4ae4-9eba-a8950f47f49f</subsheetid>
<loginhibit onsuccess="true" />
<inputs>
<input type="text" name="ConnectionName" friendlyname="ConnectionName" expr="[Blue Prism - OracleMDA_SID]" />
<input type="text" name="Hostname" friendlyname="Hostname" narrative="The IP address of the oracle host." expr="[Blue Prism - OracleMDA_Host]" />
<input type="text" name="Port" friendlyname="Port" narrative="The listening port on the oracle host." expr="[Blue Prism - OracleMDA_Port]" />
<input type="text" name="Username" friendlyname="Username" expr="[Blue Prism - OracleMDA_User]" />
<input type="password" name="Password" friendlyname="Password" expr="[Blue Prism - OracleMDA_Password]" />
</inputs>
<outputs>
<output type="text" name="ConnectionString" friendlyname="ConnectionString" stage="ConnStr" />
</outputs>
<onsuccess>53afebf6-06fd-4f53-a6d5-03d95e3d18e7</onsuccess>
<resource object="Data - Oracle (MDA)" action="Set Connection" />
<displayx>30</displayx>
<displayy>-30</displayy>
<displaywidth>120</displaywidth>
<displayheight>30</displayheight>
</stage>
<stage stageid="8369f7d0-d1d8-43fb-b6d0-61a02996b62b" name="TableToDeleteFrom" type="Data">
<subsheetid>e72a8467-73cd-4ae4-9eba-a8950f47f49f</subsheetid>
<datatype>text</datatype>
<initialvalue />
<private />
<alwaysinit />
<displayx>-240</displayx>
<displayy>-15</displayy>
<displaywidth>120</displaywidth>
<displayheight>30</displayheight>
</stage>
<stage stageid="89c65fef-5394-4fb8-947a-742eccd9f272" name="ReportExceptions" type="Data">
<subsheetid>e72a8467-73cd-4ae4-9eba-a8950f47f49f</subsheetid>
<datatype>flag</datatype>
<initialvalue>False</initialvalue>
<private />
<alwaysinit />
<displayx>-135</displayx>
<displayy>-15</displayy>
<displaywidth>120</displaywidth>
<displayheight>30</displayheight>
</stage>
<stage stageid="eac6322b-c6aa-4eb1-8782-bb22119871ee" name="WhereClause" type="Data">
<subsheetid>e72a8467-73cd-4ae4-9eba-a8950f47f49f</subsheetid>
<datatype>text</datatype>
<initialvalue xml:space="preserve">ID=6</initialvalue>
<private />
<alwaysinit />
<displayx>-255</displayx>
<displayy>30</displayy>
<displaywidth>90</displaywidth>
<displayheight>30</displayheight>
</stage>
<stage stageid="3cd506fe-4d6c-48af-9801-28f83e991a54" name="TRUNCATE TABLE" type="SubSheetInfo">
<subsheetid>607b66af-d5eb-4234-850f-6dc9ded407c3</subsheetid>
<narrative>Truncate Table will delete all the rows of a table and bypass any logging. Use this function carefully as to recover may require a restore from a backup. TableToTruncate carries the table name to truncate, ReportExceptions is a flag to detail exceptions. Message and Success will detail the outcome of the process.</narrative>
<displayx>-195</displayx>
<displayy>-105</displayy>
<displaywidth>180</displaywidth>
<displayheight>90</displayheight>
</stage>
<stage stageid="305fbc2d-a328-45ce-85e0-82a1dac78562" name="Start" type="Start">
<subsheetid>607b66af-d5eb-4234-850f-6dc9ded407c3</subsheetid>
<onsuccess>f870a29e-1196-4351-8e90-30e601ca99d1</onsuccess>
<displayx>30</displayx>
<displayy>-90</displayy>
</stage>
<stage stageid="8ce78476-df62-4705-867b-1a2f68b1e381" name="End" type="End">
<subsheetid>607b66af-d5eb-4234-850f-6dc9ded407c3</subsheetid>
<displayx>30</displayx>
<displayy>105</displayy>
</stage>
<stage stageid="fe318cbd-b6c5-4607-adb3-6c126fbce5a4" name="Data - Oracle (MDA)::Truncate Table" type="Action">
<subsheetid>607b66af-d5eb-4234-850f-6dc9ded407c3</subsheetid>
<loginhibit onsuccess="true" />
<inputs>
<input type="flag" name="ReportExceptions" friendlyname="ReportExceptions" expr="[ReportExceptions]" />
<input type="text" name="TableToTruncate" friendlyname="TableToTruncate" expr="[TableToTruncate]" />
</inputs>
<outputs>
<output type="flag" name="Success" friendlyname="Success" stage="Success" />
<output type="text" name="Message" friendlyname="Message" stage="Message" />
</outputs>
<onsuccess>8ce78476-df62-4705-867b-1a2f68b1e381</onsuccess>
<resource object="Data - Oracle (MDA)" action="Truncate Table" />
<displayx>30</displayx>
<displayy>30</displayy>
<displaywidth>120</displaywidth>
<displayheight>30</displayheight>
</stage>
<stage stageid="7cde3de7-a233-4fbf-aadd-f26a278c86d6" name="Success" type="Data">
<subsheetid>607b66af-d5eb-4234-850f-6dc9ded407c3</subsheetid>
<datatype>flag</datatype>
<initialvalue />
<private />
<alwaysinit />
<displayx>-150</displayx>
<displayy>105</displayy>
</stage>
<stage stageid="942bc255-6397-42ed-b87d-183020830604" name="Message" type="Data">
<subsheetid>607b66af-d5eb-4234-850f-6dc9ded407c3</subsheetid>
<datatype>text</datatype>
<initialvalue />
<private />
<alwaysinit />
<displayx>-225</displayx>
<displayy>105</displayy>
<displaywidth>90</displaywidth>
<displayheight>30</displayheight>
</stage>
<stage stageid="f870a29e-1196-4351-8e90-30e601ca99d1" name="Data - Oracle (MDA)::Set Connection" type="Action">
<subsheetid>607b66af-d5eb-4234-850f-6dc9ded407c3</subsheetid>
<loginhibit onsuccess="true" />
<inputs>
<input type="text" name="ConnectionName" friendlyname="ConnectionName" expr="[Blue Prism - OracleMDA_SID]" />
<input type="text" name="Hostname" friendlyname="Hostname" narrative="The IP address of the oracle host." expr="[Blue Prism - OracleMDA_Host]" />
<input type="text" name="Port" friendlyname="Port" narrative="The listening port on the oracle host." expr="[Blue Prism - OracleMDA_Port]" />
<input type="text" name="Username" friendlyname="Username" expr="[Blue Prism - OracleMDA_User]" />
<input type="password" name="Password" friendlyname="Password" expr="[Blue Prism - OracleMDA_Password]" />
</inputs>
<outputs>
<output type="text" name="ConnectionString" friendlyname="ConnectionString" stage="ConnStr" />
</outputs>
<onsuccess>fe318cbd-b6c5-4607-adb3-6c126fbce5a4</onsuccess>
<resource object="Data - Oracle (MDA)" action="Set Connection" />
<displayx>30</displayx>
<displayy>-30</displayy>
<displaywidth>120</displaywidth>
<displayheight>30</displayheight>
</stage>
<stage stageid="c370a385-df00-4ba7-bcd3-ef0713dc3d44" name="TableToTruncate" type="Data">
<subsheetid>607b66af-d5eb-4234-850f-6dc9ded407c3</subsheetid>
<datatype>text</datatype>
<initialvalue />
<private />
<alwaysinit />
<displayx>-195</displayx>
<displayy>-15</displayy>
<displaywidth>120</displaywidth>
<displayheight>30</displayheight>
</stage>
<stage stageid="1590cef9-4ea9-4908-8d2e-a870d2c7ea7a" name="ReportExceptions" type="Data">
<subsheetid>607b66af-d5eb-4234-850f-6dc9ded407c3</subsheetid>
<datatype>flag</datatype>
<initialvalue>False</initialvalue>
<private />
<alwaysinit />
<displayx>-195</displayx>
<displayy>30</displayy>
<displaywidth>120</displaywidth>
<displayheight>30</displayheight>
</stage>
<stage stageid="6724299b-e473-4083-8b6c-1389dda34a0e" name="Get Machine Name" type="SubSheetInfo">
<subsheetid>1a7f8351-c5c0-4486-b1be-7edaa9b3b888</subsheetid>
<narrative>This is an environment function. It does not contact the Oracle Database. It simply makes a call to the computing environment and returns the computer name.</narrative>
<displayx>-195</displayx>
<displayy>-105</displayy>
<displaywidth>150</displaywidth>
<displayheight>90</displayheight>
</stage>
<stage stageid="8d136d64-3f4a-4de5-8193-c11cd05c5c80" name="Start" type="Start">
<subsheetid>1a7f8351-c5c0-4486-b1be-7edaa9b3b888</subsheetid>
<onsuccess>fa881d9a-0b9a-4611-a32b-d0bbf99d7fc0</onsuccess>
<displayx>15</displayx>
<displayy>-105</displayy>
</stage>
<stage stageid="5415a1a6-7613-42c6-ae66-2a70f4249808" name="End" type="End">
<subsheetid>1a7f8351-c5c0-4486-b1be-7edaa9b3b888</subsheetid>
<displayx>15</displayx>
<displayy>90</displayy>
</stage>
<stage stageid="fa881d9a-0b9a-4611-a32b-d0bbf99d7fc0" name="Data - Oracle (MDA)::Get Machine Name" type="Action">
<subsheetid>1a7f8351-c5c0-4486-b1be-7edaa9b3b888</subsheetid>
<loginhibit onsuccess="true" />
<outputs>
<output type="text" name="machine name" friendlyname="machine name" stage="machine name" />
</outputs>
<onsuccess>5415a1a6-7613-42c6-ae66-2a70f4249808</onsuccess>
<resource object="Data - Oracle (MDA)" action="Get Machine Name" />
<displayx>15</displayx>
<displayy>-15</displayy>
<displaywidth>120</displaywidth>
<displayheight>30</displayheight>
</stage>
<stage stageid="b13fe58b-c4ea-43fe-86b1-ad4369d8b7aa" name="machine name" type="Data">
<subsheetid>1a7f8351-c5c0-4486-b1be-7edaa9b3b888</subsheetid>
<datatype>text</datatype>
<initialvalue />
<private />
<alwaysinit />
<displayx>-195</displayx>
<displayy>0</displayy>
<displaywidth>120</displaywidth>
<displayheight>30</displayheight>
</stage>
<stage stageid="7894819c-20a3-4dd5-a777-27a8610e7d69" name="Get User Name" type="SubSheetInfo">
<subsheetid>fbee9ab3-c882-4b15-93b3-7b51b3b60772</subsheetid>
<narrative>This is an environment function. It does not contact the Oracle Database. It simply makes a call to the computing environment and returns the user name.</narrative>
<displayx>-195</displayx>
<displayy>-105</displayy>
<displaywidth>150</displaywidth>
<displayheight>90</displayheight>
</stage>
<stage stageid="aaa64880-6d54-4f7d-aacf-296defd410d7" name="Start" type="Start">
<subsheetid>fbee9ab3-c882-4b15-93b3-7b51b3b60772</subsheetid>
<onsuccess>e064082c-07c0-4aaa-a1ee-4cf8470a101e</onsuccess>
<displayx>15</displayx>
<displayy>-105</displayy>
</stage>
<stage stageid="74a06db3-6852-4325-b7c2-b7caaff81fff" name="End" type="End">
<subsheetid>fbee9ab3-c882-4b15-93b3-7b51b3b60772</subsheetid>
<displayx>15</displayx>
<displayy>90</displayy>
</stage>
<stage stageid="e064082c-07c0-4aaa-a1ee-4cf8470a101e" name="Data - Oracle (MDA)::Get User Name" type="Action">
<subsheetid>fbee9ab3-c882-4b15-93b3-7b51b3b60772</subsheetid>
<loginhibit onsuccess="true" />
<outputs>
<output type="text" name="user name" friendlyname="user name" stage="user name" />
</outputs>
<onsuccess>74a06db3-6852-4325-b7c2-b7caaff81fff</onsuccess>
<resource object="Data - Oracle (MDA)" action="Get User Name" />
<displayx>15</displayx>
<displayy>-15</displayy>
</stage>
<stage stageid="9c0f72f8-84c7-4481-b244-2f8d8ea0d3b6" name="user name" type="Data">
<subsheetid>fbee9ab3-c882-4b15-93b3-7b51b3b60772</subsheetid>
<datatype>text</datatype>
<initialvalue />
<private />
<alwaysinit />
<displayx>-195</displayx>
<displayy>15</displayy>
<displaywidth>120</displaywidth>
<displayheight>30</displayheight>
</stage>
<stage stageid="8a9d5c2e-1580-4712-9889-4b65302d6796" name="Get CSV " type="SubSheetInfo">
<subsheetid>e51225a7-9878-4669-aa28-7b96c3892373</subsheetid>
<narrative>Enter a valid SQL Select statement into the SQL data item. This will return a string of comma separated variables into the CSV data item. Note that schema understanding will be required here.</narrative>
<displayx>-180</displayx>
<displayy>-105</displayy>
<displaywidth>180</displaywidth>
<displayheight>90</displayheight>
</stage>
<stage stageid="6910f83d-34dc-4125-aa87-a51aa2d49e7f" name="Start" type="Start">
<subsheetid>e51225a7-9878-4669-aa28-7b96c3892373</subsheetid>
<onsuccess>d070b74b-e597-45be-8270-4ee57e663f84</onsuccess>
<displayx>15</displayx>
<displayy>-105</displayy>
</stage>
<stage stageid="8fee0e82-5df9-42db-bbc2-4fe736d61c12" name="End" type="End">
<subsheetid>e51225a7-9878-4669-aa28-7b96c3892373</subsheetid>
<displayx>15</displayx>
<displayy>90</displayy>
</stage>
<stage stageid="d070b74b-e597-45be-8270-4ee57e663f84" name="Data - Oracle (MDA)::Get CSV" type="Action">
<subsheetid>e51225a7-9878-4669-aa28-7b96c3892373</subsheetid>
<loginhibit onsuccess="true" />
<inputs>
<input type="text" name="Query" friendlyname="Query" expr="[SQL]" />
</inputs>
<outputs>
<output type="flag" name="Success" friendlyname="Success" stage="Success" />
<output type="text" name="Message" friendlyname="Message" stage="Message" />
<output type="text" name="CSV" friendlyname="CSV" stage="CSV" />
</outputs>
<onsuccess>8fee0e82-5df9-42db-bbc2-4fe736d61c12</onsuccess>
<resource object="Data - Oracle (MDA)" action="Get CSV" />
<displayx>15</displayx>
<displayy>-15</displayy>
</stage>
<stage stageid="77177be9-3bd5-4f23-92b5-19c5402bf4bf" name="SQL" type="Data">
<subsheetid>e51225a7-9878-4669-aa28-7b96c3892373</subsheetid>
<datatype>text</datatype>
<initialvalue xml:space="preserve">Select * from [Table]</initialvalue>
<private />
<alwaysinit />
<displayx>-180</displayx>
<displayy>-15</displayy>
<displaywidth>150</displaywidth>
<displayheight>30</displayheight>
</stage>
<stage stageid="7d868236-7df0-4b03-b30c-f4f3a1e9e397" name="CSV" type="Data">
<subsheetid>e51225a7-9878-4669-aa28-7b96c3892373</subsheetid>
<datatype>text</datatype>
<initialvalue />
<private />
<alwaysinit />
<displayx>-180</displayx>
<displayy>105</displayy>
<displaywidth>150</displaywidth>
<displayheight>30</displayheight>
</stage>
<stage stageid="6cecdf1a-8759-4325-9569-ec23ff0dd5ac" name="Message" type="Data">
<subsheetid>e51225a7-9878-4669-aa28-7b96c3892373</subsheetid>
<datatype>text</datatype>
<initialvalue />
<private />
<alwaysinit />
<displayx>-135</displayx>
<displayy>60</displayy>
</stage>
<stage stageid="d2d8bd6f-f362-40f0-9fbd-5e016a89d3b3" name="Success" type="Data">
<subsheetid>e51225a7-9878-4669-aa28-7b96c3892373</subsheetid>
<datatype>flag</datatype>
<initialvalue />
<private />
<alwaysinit />
<displayx>-225</displayx>
<displayy>60</displayy>
</stage>
<stage stageid="2eab9341-85b0-48f6-b16b-cc57a90866cb" name="Get CSV File" type="SubSheetInfo">
<subsheetid>1d6d6457-faf8-4638-8009-7e1399aa73b0</subsheetid>
<displayx>-180</displayx>
<displayy>-105</displayy>
<displaywidth>180</displaywidth>
<displayheight>90</displayheight>
</stage>
<stage stageid="9dc885f1-894f-479b-80dd-90ad26acbeea" name="Start" type="Start">
<subsheetid>1d6d6457-faf8-4638-8009-7e1399aa73b0</subsheetid>
<onsuccess>0cc3926b-00e6-4e02-8286-1bad4a33e0b1</onsuccess>
<displayx>15</displayx>
<displayy>-105</displayy>
</stage>
<stage stageid="a6629b97-52aa-4ae8-aeed-c6e576a13bf2" name="End" type="End">
<subsheetid>1d6d6457-faf8-4638-8009-7e1399aa73b0</subsheetid>
<displayx>15</displayx>
<displayy>90</displayy>
</stage>
<stage stageid="0cc3926b-00e6-4e02-8286-1bad4a33e0b1" name="Data - Oracle (MDA)::Get CSV File" type="Action">
<subsheetid>1d6d6457-faf8-4638-8009-7e1399aa73b0</subsheetid>
<loginhibit onsuccess="true" />
<inputs>
<input type="text" name="CSVFilename" friendlyname="CSVFilename" expr="[CSVFilename]" />
<input type="text" name="SelectQuery" friendlyname="SelectQuery" expr="[SQL]" />
</inputs>
<outputs>
<output type="flag" name="Success" friendlyname="Success" stage="Success" />
<output type="text" name="Message" friendlyname="Message" stage="Message" />
</outputs>
<onsuccess>a6629b97-52aa-4ae8-aeed-c6e576a13bf2</onsuccess>
<resource object="Data - Oracle (MDA)" action="Get CSV File" />
<displayx>15</displayx>
<displayy>15</displayy>
<displaywidth>90</displaywidth>
<displayheight>30</displayheight>
</stage>
<stage stageid="4c7b7958-3e4b-4238-bac2-dc0dfa94ea7b" name="SQL" type="Data">
<subsheetid>1d6d6457-faf8-4638-8009-7e1399aa73b0</subsheetid>
<datatype>text</datatype>
<initialvalue xml:space="preserve">Select * from [Table]</initialvalue>
<private />
<alwaysinit />
<displayx>-180</displayx>
<displayy>-15</displayy>
<displaywidth>120</displaywidth>
<displayheight>30</displayheight>
</stage>
<stage stageid="2c45cfe9-c8e0-458f-bd65-8f6f2ab7e60d" name="CSVFilename" type="Data">
<subsheetid>1d6d6457-faf8-4638-8009-7e1399aa73b0</subsheetid>
<datatype>text</datatype>
<initialvalue xml:space="preserve">E:\OracleData.CSV</initialvalue>
<private />
<alwaysinit />
<displayx>-180</displayx>
<displayy>30</displayy>
<displaywidth>150</displaywidth>
<displayheight>30</displayheight>
</stage>
<stage stageid="6cc99d7a-45e1-4fba-b4e5-9559c0bb2b67" name="Success" type="Data">
<subsheetid>1d6d6457-faf8-4638-8009-7e1399aa73b0</subsheetid>
<datatype>flag</datatype>
<initialvalue />
<private />
<alwaysinit />
<displayx>-225</displayx>
<displayy>105</displayy>
</stage>
<stage stageid="1d26e8a7-5833-4e2b-bfea-8096dd17308e" name="Message" type="Data">
<subsheetid>1d6d6457-faf8-4638-8009-7e1399aa73b0</subsheetid>
<datatype>text</datatype>
<initialvalue />
<private />
<alwaysinit />
<displayx>-135</displayx>
<displayy>105</displayy>
</stage>
<stage stageid="90901cf9-47a7-4af7-8da9-fa1f26607853" name="Transaction - Commit" type="SubSheetInfo">
<subsheetid>b7fd8cc2-f883-437e-8560-fb8d0c6c2c66</subsheetid>
<narrative>This is a sample of a full transaction, showing begin and commit.</narrative>
<displayx>-195</displayx>
<displayy>-120</displayy>
<displaywidth>150</displaywidth>
<displayheight>90</displayheight>
</stage>
<stage stageid="f583e895-da8f-45b3-9a3a-5fac3ec6a381" name="Start" type="Start">
<subsheetid>b7fd8cc2-f883-437e-8560-fb8d0c6c2c66</subsheetid>
<onsuccess>c701c7d4-d738-47cf-8713-fdaf16164821</onsuccess>
<displayx>15</displayx>
<displayy>-150</displayy>
</stage>
<stage stageid="89ee9714-effc-4bec-8ac2-e2b1128517d0" name="End" type="End">
<subsheetid>b7fd8cc2-f883-437e-8560-fb8d0c6c2c66</subsheetid>
<displayx>15</displayx>
<displayy>150</displayy>
</stage>
<stage stageid="c701c7d4-d738-47cf-8713-fdaf16164821" name="Data - Oracle (MDA)::Begin Transaction" type="Action">
<subsheetid>b7fd8cc2-f883-437e-8560-fb8d0c6c2c66</subsheetid>
<loginhibit onsuccess="true" />
<outputs>
<output type="flag" name="Success" friendlyname="Success" stage="Success" />
<output type="text" name="Message" friendlyname="Message" stage="Message" />
</outputs>
<onsuccess>f58358e7-6d23-4fd8-b7eb-79d7d2717a0e</onsuccess>
<resource object="Data - Oracle (MDA)" action="Begin Transaction" />
<displayx>15</displayx>
<displayy>-90</displayy>
</stage>
<stage stageid="15ae714d-b9b6-42f4-89d7-a66a8e588cab" name="Success" type="Data">
<subsheetid>b7fd8cc2-f883-437e-8560-fb8d0c6c2c66</subsheetid>
<datatype>flag</datatype>
<initialvalue />
<private />
<alwaysinit />
<displayx>-255</displayx>
<displayy>120</displayy>
</stage>
<stage stageid="6c5f82c3-1e70-4a4b-b99f-c180dbf1abea" name="Message" type="Data">
<subsheetid>b7fd8cc2-f883-437e-8560-fb8d0c6c2c66</subsheetid>
<datatype>text</datatype>
<initialvalue />
<private />
<alwaysinit />
<displayx>-150</displayx>
<displayy>120</displayy>
<displaywidth>90</displaywidth>
<displayheight>30</displayheight>
</stage>
<stage stageid="f58358e7-6d23-4fd8-b7eb-79d7d2717a0e" name="Data - Oracle (MDA)::Execute" type="Action">
<subsheetid>b7fd8cc2-f883-437e-8560-fb8d0c6c2c66</subsheetid>
<loginhibit onsuccess="true" />
<inputs>
<input type="text" name="Query" friendlyname="Query" expr="[SQL]" />
</inputs>
<outputs>
<output type="flag" name="Success" friendlyname="Success" stage="Success" />
<output type="text" name="Message" friendlyname="Message" stage="Message" />
</outputs>
<onsuccess>de1e3a81-8c38-415e-922e-739e7b9d306b</onsuccess>
<resource object="Data - Oracle (MDA)" action="Execute" />
<displayx>15</displayx>
<displayy>-30</displayy>
</stage>
<stage stageid="41a22e0c-5da6-4669-b8b3-4a628bea102a" name="SQL" type="Data">
<subsheetid>b7fd8cc2-f883-437e-8560-fb8d0c6c2c66</subsheetid>
<datatype>text</datatype>
<initialvalue xml:space="preserve">INSERT INTO [Table]
Values ([v1,v2,v3)</initialvalue>
<private />
<alwaysinit />
<displayx>-195</displayx>
<displayy>-15</displayy>
<displaywidth>180</displaywidth>
<displayheight>30</displayheight>
</stage>
<stage stageid="de1e3a81-8c38-415e-922e-739e7b9d306b" name="Data - Oracle (MDA)::Commit Transaction" type="Action">
<subsheetid>b7fd8cc2-f883-437e-8560-fb8d0c6c2c66</subsheetid>
<loginhibit onsuccess="true" />
<outputs>
<output type="flag" name="Success" friendlyname="Success" stage="Success" />
<output type="text" name="Message" friendlyname="Message" stage="Message" />
</outputs>
<onsuccess>d9bd80f8-f376-42ec-886b-728db0d91558</onsuccess>
<resource object="Data - Oracle (MDA)" action="Commit Transaction" />
<displayx>15</displayx>
<displayy>30</displayy>
</stage>
<stage stageid="237cd573-c092-4055-a522-6d51b9f65bb4" name="SQL1" type="Data">
<subsheetid>b7fd8cc2-f883-437e-8560-fb8d0c6c2c66</subsheetid>
<datatype>text</datatype>
<initialvalue xml:space="preserve">Select * from [Table] where ID=[Value]</initialvalue>
<private />
<alwaysinit />
<displayx>-195</displayx>
<displayy>45</displayy>
<displaywidth>210</displaywidth>
<displayheight>30</displayheight>
</stage>
<stage stageid="d9bd80f8-f376-42ec-886b-728db0d91558" name="Data - Oracle (MDA)::Execute" type="Action">
<subsheetid>b7fd8cc2-f883-437e-8560-fb8d0c6c2c66</subsheetid>
<loginhibit onsuccess="true" />
<inputs>
<input type="text" name="Query" friendlyname="Query" expr="[SQL1]" />
</inputs>
<outputs>
<output type="flag" name="Success" friendlyname="Success" stage="Success" />
<output type="text" name="Message" friendlyname="Message" stage="Message" />
<output type="number" name="RecordsAffected" friendlyname="RecordsAffected" stage="RecordsAffected" />
</outputs>
<onsuccess>89ee9714-effc-4bec-8ac2-e2b1128517d0</onsuccess>
<resource object="Data - Oracle (MDA)" action="Execute" />
<displayx>15</displayx>
<displayy>90</displayy>
</stage>
<stage stageid="1197abb8-e911-47e5-826a-c9ad4231825e" name="Get Collection" type="SubSheetInfo">
<subsheetid>00bad46a-aff4-4971-970b-01b796172688</subsheetid>
<narrative>This function takes in a valid SQL Select script and returns the results in a Blue Prism Collection.</narrative>
<displayx>-195</displayx>
<displayy>-105</displayy>
<displaywidth>150</displaywidth>
<displayheight>90</displayheight>
</stage>
<stage stageid="762ee602-98a3-4a6f-8b4b-cae40c299413" name="Start" type="Start">
<subsheetid>00bad46a-aff4-4971-970b-01b796172688</subsheetid>
<onsuccess>1ad1e55b-1cac-4f52-b0ce-d64fd6b795b8</onsuccess>
<displayx>15</displayx>
<displayy>-105</displayy>
</stage>
<stage stageid="9ebce978-91ff-4b1c-a737-bb52d318ed16" name="End" type="End">
<subsheetid>00bad46a-aff4-4971-970b-01b796172688</subsheetid>
<displayx>15</displayx>
<displayy>90</displayy>
</stage>
<stage stageid="5d11970d-867e-439a-be3b-42b14d03e4ef" name="Data - Oracle (MDA)::Get Collection" type="Action">
<subsheetid>00bad46a-aff4-4971-970b-01b796172688</subsheetid>
<loginhibit onsuccess="true" />
<inputs>
<input type="text" name="Query" friendlyname="Query" expr="[SQL]" />
</inputs>
<outputs>
<output type="flag" name="Success" friendlyname="Success" stage="Success" />
<output type="text" name="Message" friendlyname="Message" stage="Message" />
<output type="collection" name="Result" friendlyname="Result" stage="Result" />
</outputs>
<onsuccess>9ebce978-91ff-4b1c-a737-bb52d318ed16</onsuccess>
<resource object="Data - Oracle (MDA)" action="Get Collection" />
<displayx>15</displayx>
<displayy>15</displayy>
<displaywidth>90</displaywidth>
<displayheight>30</displayheight>
</stage>
<stage stageid="246b2a4a-26c7-4ccd-8b89-c45ab2cc0c3f" name="SQL" type="Data">
<subsheetid>00bad46a-aff4-4971-970b-01b796172688</subsheetid>
<datatype>text</datatype>
<initialvalue xml:space="preserve">Select * from [Table]</initialvalue>
<private />
<alwaysinit />
<displayx>-195</displayx>
<displayy>-15</displayy>
</stage>
<stage stageid="29c7ad02-947f-4042-bfdd-d6659edccb6f" name="Success" type="Data">
<subsheetid>00bad46a-aff4-4971-970b-01b796172688</subsheetid>
<datatype>flag</datatype>
<initialvalue />
<private />
<alwaysinit />
<displayx>-165</displayx>
<displayy>75</displayy>
</stage>
<stage stageid="b8449c48-97bd-47e6-b156-c0e0263a36ce" name="Message" type="Data">
<subsheetid>00bad46a-aff4-4971-970b-01b796172688</subsheetid>
<datatype>text</datatype>
<initialvalue />
<private />
<alwaysinit />
<displayx>-225</displayx>
<displayy>75</displayy>
</stage>
<stage stageid="5a99787a-e509-4076-ae1c-3dd431c68309" name="Result" type="Collection">
<subsheetid>00bad46a-aff4-4971-970b-01b796172688</subsheetid>
<datatype>collection</datatype>
<private />
<alwaysinit />
<displayx>-195</displayx>
<displayy>120</displayy>
</stage>
<stage stageid="1ad1e55b-1cac-4f52-b0ce-d64fd6b795b8" name="Data - Oracle (MDA)::Set Connection" type="Action">
<subsheetid>00bad46a-aff4-4971-970b-01b796172688</subsheetid>
<loginhibit onsuccess="true" />
<inputs>
<input type="text" name="ConnectionName" friendlyname="ConnectionName" expr="[Blue Prism - OracleMDA_SID]" />
<input type="text" name="Hostname" friendlyname="Hostname" narrative="The IP address of the oracle host." expr="[Blue Prism - OracleMDA_Host]" />
<input type="text" name="Port" friendlyname="Port" narrative="The listening port on the oracle host." expr="[Blue Prism - OracleMDA_Port]" />
<input type="text" name="Username" friendlyname="Username" expr="[Blue Prism - OracleMDA_User]" />
<input type="password" name="Password" friendlyname="Password" expr="[Blue Prism - OracleMDA_Password]" />
</inputs>
<outputs>
<output type="text" name="ConnectionString" friendlyname="ConnectionString" stage="ConnStr" />
</outputs>
<onsuccess>5d11970d-867e-439a-be3b-42b14d03e4ef</onsuccess>
<resource object="Data - Oracle (MDA)" action="Set Connection" />
<displayx>15</displayx>
<displayy>-45</displayy>
<displaywidth>90</displaywidth>
<displayheight>30</displayheight>
</stage>
<stage stageid="313c9f94-2f02-49ff-a92d-904db21c7caa" name="RecordsAffected" type="Data">
<subsheetid>b7fd8cc2-f883-437e-8560-fb8d0c6c2c66</subsheetid>
<datatype>number</datatype>
<initialvalue />
<private />
<alwaysinit />
<displayx>-195</displayx>
<displayy>165</displayy>
<displaywidth>120</displaywidth>
<displayheight>30</displayheight>
</stage>
<stage stageid="b488bae0-bde9-4fe3-ab1b-b3e7c4133a72" name="Inputs" type="Block">
<subsheetid>40b71b60-2c56-4235-9d5d-482a0f568d00</subsheetid>
<font family="Segoe UI" size="10" style="Regular" color="FFFF00" />
<displayx>-270</displayx>
<displayy>-45</displayy>
<displaywidth>180</displaywidth>
<displayheight>120</displayheight>
</stage>
<stage stageid="20913c95-9075-4711-9702-a18ca8475531" name="Outputs" type="Block">
<subsheetid>40b71b60-2c56-4235-9d5d-482a0f568d00</subsheetid>
<font family="Segoe UI" size="10" style="Regular" color="00FF00" />
<displayx>-270</displayx>
<displayy>90</displayy>
<displaywidth>180</displaywidth>
<displayheight>60</displayheight>
</stage>
<stage stageid="26181a56-f270-4940-9148-bf6b175f6de2" name="Outputs" type="Block">
<subsheetid>e72a8467-73cd-4ae4-9eba-a8950f47f49f</subsheetid>
<font family="Segoe UI" size="10" style="Regular" color="00FF00" />
<displayx>-315</displayx>
<displayy>75</displayy>
<displaywidth>180</displaywidth>
<displayheight>60</displayheight>
</stage>
<stage stageid="f5faf8cb-daa6-467f-bd09-3b598de09191" name="Inputs" type="Block">
<subsheetid>e72a8467-73cd-4ae4-9eba-a8950f47f49f</subsheetid>
<font family="Segoe UI" size="10" style="Regular" color="FFFF00" />
<displayx>-315</displayx>
<displayy>-45</displayy>
<displaywidth>255</displaywidth>
<displayheight>105</displayheight>
</stage>
<stage stageid="b51b5ecd-5ece-43cd-ba16-946043b65b52" name="Outputs" type="Block">
<subsheetid>607b66af-d5eb-4234-850f-6dc9ded407c3</subsheetid>
<font family="Segoe UI" size="10" style="Regular" color="00FF00" />
<displayx>-285</displayx>
<displayy>75</displayy>
<displaywidth>180</displaywidth>
<displayheight>60</displayheight>
</stage>
<stage stageid="1256918d-4066-4536-bca1-bacfb4d85552" name="Inputs" type="Block">
<subsheetid>607b66af-d5eb-4234-850f-6dc9ded407c3</subsheetid>
<font family="Segoe UI" size="10" style="Regular" color="FFFF00" />
<displayx>-285</displayx>
<displayy>-45</displayy>
<displaywidth>180</displaywidth>
<displayheight>105</displayheight>
</stage>
<stage stageid="8d7a0c8a-f706-4368-a809-f858ac1e7763" name="Outputs" type="Block">
<subsheetid>e51225a7-9878-4669-aa28-7b96c3892373</subsheetid>
<font family="Segoe UI" size="10" style="Regular" color="00FF00" />
<displayx>-270</displayx>
<displayy>30</displayy>
<displaywidth>180</displaywidth>
<displayheight>105</displayheight>
</stage>
<stage stageid="06cb1a57-e3c9-40b8-8675-46707387a9b2" name="Inputs" type="Block">
<subsheetid>e51225a7-9878-4669-aa28-7b96c3892373</subsheetid>
<font family="Segoe UI" size="10" style="Regular" color="FFFF00" />
<displayx>-270</displayx>
<displayy>-45</displayy>
<displaywidth>180</displaywidth>
<displayheight>60</displayheight>
</stage>
<stage stageid="0431553c-1cc1-490f-a2d6-2fa25d4b676c" name="Outputs" type="Block">
<subsheetid>1d6d6457-faf8-4638-8009-7e1399aa73b0</subsheetid>
<font family="Segoe UI" size="10" style="Regular" color="00FF00" />
<displayx>-270</displayx>
<displayy>75</displayy>
<displaywidth>180</displaywidth>
<displayheight>60</displayheight>
</stage>
<stage stageid="fcf65f64-6bd9-4967-b879-7946197dccff" name="Inputs" type="Block">
<subsheetid>1d6d6457-faf8-4638-8009-7e1399aa73b0</subsheetid>
<font family="Segoe UI" size="10" style="Regular" color="FFFF00" />
<displayx>-270</displayx>
<displayy>-45</displayy>
<displaywidth>180</displaywidth>
<displayheight>105</displayheight>
</stage>
<stage stageid="2ddbafd5-b4d1-4ab9-a518-3308faf3ba91" name="Inputs" type="Block">
<subsheetid>b7fd8cc2-f883-437e-8560-fb8d0c6c2c66</subsheetid>
<font family="Segoe UI" size="10" style="Regular" color="FFFF00" />
<displayx>-300</displayx>
<displayy>-45</displayy>
<displaywidth>210</displaywidth>
<displayheight>120</displayheight>
</stage>
<stage stageid="e1a5b0e0-ab07-4c67-9bc5-4c206815017a" name="Outputs" type="Block">
<subsheetid>b7fd8cc2-f883-437e-8560-fb8d0c6c2c66</subsheetid>
<font family="Segoe UI" size="10" style="Regular" color="00FF00" />
<displayx>-300</displayx>
<displayy>90</displayy>
<displaywidth>210</displaywidth>
<displayheight>105</displayheight>
</stage>
<stage stageid="8a9b5a9a-be44-4624-9bae-f13421b1d317" name="Outputs" type="Block">
<subsheetid>1a7f8351-c5c0-4486-b1be-7edaa9b3b888</subsheetid>
<font family="Segoe UI" size="10" style="Regular" color="00FF00" />
<displayx>-270</displayx>
<displayy>-30</displayy>
<displaywidth>150</displaywidth>
<displayheight>60</displayheight>
</stage>
<stage stageid="39723be0-2fd6-4340-ad53-576a647acc0c" name="Outputs" type="Block">
<subsheetid>fbee9ab3-c882-4b15-93b3-7b51b3b60772</subsheetid>
<font family="Segoe UI" size="10" style="Regular" color="00FF00" />
<displayx>-270</displayx>
<displayy>-15</displayy>
<displaywidth>150</displaywidth>
<displayheight>60</displayheight>
</stage>
<stage stageid="3c225a1e-643d-46ea-87dc-fa31feb86181" name="Outputs" type="Block">
<subsheetid>00bad46a-aff4-4971-970b-01b796172688</subsheetid>
<font family="Segoe UI" size="10" style="Regular" color="00FF00" />
<displayx>-270</displayx>
<displayy>45</displayy>
<displaywidth>150</displaywidth>
<displayheight>105</displayheight>
</stage>
<stage stageid="da3a56e1-1a0e-45df-99a0-19a42f525606" name="Inputs" type="Block">
<subsheetid>00bad46a-aff4-4971-970b-01b796172688</subsheetid>
<font family="Segoe UI" size="10" style="Regular" color="FFFF00" />
<displayx>-270</displayx>
<displayy>-45</displayy>
<displaywidth>150</displaywidth>
<displayheight>60</displayheight>
</stage>
<stage stageid="a7891c45-fe0b-49e5-9698-a8752cd91c31" name="Shared Variables" type="Block">
<font family="Segoe UI" size="10" style="Regular" color="FFCC00" />
<displayx>-300</displayx>
<displayy>-45</displayy>
<displaywidth>210</displaywidth>
<displayheight>285</displayheight>
</stage>
</process>
</process>
<object id="8681616d-c07d-4948-894a-36865708e237" name="Blue Prism - Oracle MDA" xmlns="http://www.blueprism.co.uk/product/process">
<process name="Blue Prism - Oracle MDA" version="1.0" bpversion="6.9.0.26970" narrative="" byrefcollection="true" type="object" runmode="Exclusive">
<appdef>
<element name="Application Root">
<id>b51d847c-a253-4723-b8b2-9791ac429d78</id>
<type>Application</type>
<basetype>Application</basetype>
<datatype>unknown</datatype>
<diagnose>False</diagnose>
</element>
</appdef>
<view>
<camerax>64</camerax>
<cameray>39</cameray>
<zoom version="2">1.25</zoom>
</view>
<preconditions />
<endpoint narrative="" />
<subsheet subsheetid="72c790c5-372a-4eb5-804b-5ee825cbdf29" type="CleanUp" published="True">
<name>Clean Up</name>
<view>
<camerax>0</camerax>
<cameray>0</cameray>
<zoom version="2">1.25</zoom>
</view>
</subsheet>
<subsheet subsheetid="ccacb83a-6ee1-4fc5-9c2b-d09215a4f561" type="Normal" published="True">
<name>Configure</name>
<view>
<camerax>0</camerax>
<cameray>-30</cameray>
<zoom version="2">1.25</zoom>
</view>
</subsheet>
<subsheet subsheetid="88b62fd7-41a8-4bc7-806a-bd8e1b5497ca" type="Normal" published="False">
<name>Raise Exception If Appropriate</name>
<view>
<camerax>-102</camerax>
<cameray>3</cameray>
<zoom version="2">1.25</zoom>
</view>
</subsheet>
<subsheet subsheetid="241b279e-d44c-422b-9421-669b95323468" type="Normal" published="True">
<name>Set Connection</name>
<view>
<camerax>0</camerax>
<cameray>21</cameray>
<zoom version="2">1.25</zoom>
</view>
</subsheet>
<subsheet subsheetid="d7f92fab-b3c7-4c06-ae2d-503e20b73fd7" type="Normal" published="False">
<name>Open</name>
<view>
<camerax>-56</camerax>
<cameray>0</cameray>
<zoom version="2">1.25</zoom>
</view>
</subsheet>
<subsheet subsheetid="3a8c9643-d2ff-4ff3-a035-cde16e518ba8" type="Normal" published="False">
<name>Close</name>
<view>
<camerax>0</camerax>
<cameray>0</cameray>
<zoom version="2">1.25</zoom>
</view>
</subsheet>
<subsheet subsheetid="ea43971d-49fa-4f4e-9f46-9fc8bc6135b0" type="Normal" published="False">
<name>Is Open</name>
<view>
<camerax>-41</camerax>
<cameray>0</cameray>
<zoom version="2">1.25</zoom>
</view>
</subsheet>
<subsheet subsheetid="f64b457a-dfb7-4200-9a9f-5dd147561478" type="Normal" published="False">
<name>Internal Close</name>
<view>
<camerax>-1</camerax>
<cameray>15</cameray>
<zoom version="2">1.25</zoom>
</view>
</subsheet>
<subsheet subsheetid="bad96847-65f0-40bc-be35-8d593764ca18" type="Normal" published="True">
<name>Begin Transaction</name>
<view>
<camerax>-20</camerax>
<cameray>45</cameray>
<zoom version="2">1.25</zoom>
</view>
</subsheet>
<subsheet subsheetid="a487438c-3391-4a66-a1a6-5f40ebc64115" type="Normal" published="True">
<name>Commit Transaction</name>
<view>
<camerax>0</camerax>
<cameray>42</cameray>
<zoom version="2">1.25</zoom>
</view>
</subsheet>
<subsheet subsheetid="fe9fac62-8a9a-4b7d-846c-418f73082557" type="Normal" published="True">
<name>Rollback Transaction</name>
<view>
<camerax>0</camerax>
<cameray>21</cameray>
<zoom version="2">1.25</zoom>
</view>
</subsheet>
<subsheet subsheetid="540e741c-c8b3-4b39-9574-4abc24bd8bc9" type="Normal" published="True">
<name>Execute</name>
<view>
<camerax>-53</camerax>
<cameray>37</cameray>
<zoom version="2">1.25</zoom>
</view>
</subsheet>
<subsheet subsheetid="032119f9-342d-4b7e-ab12-c018b781a2f3" type="Normal" published="True">
<name>Get Number</name>
<view>
<camerax>-112</camerax>
<cameray>10</cameray>
<zoom version="2">1.25</zoom>
</view>
</subsheet>
<subsheet subsheetid="48d79c6a-7dc2-4a23-a601-7421f7fb5280" type="Normal" published="True">
<name>Get Text</name>
<view>
<camerax>-225</camerax>
<cameray>-21</cameray>
<zoom version="2">1.25</zoom>
</view>
</subsheet>
<subsheet subsheetid="a05c17eb-69e9-4f1e-b50c-cc1c353eef22" type="Normal" published="True">
<name>Get Collection</name>
<view>
<camerax>-188</camerax>
<cameray>42</cameray>
<zoom version="2">1.25</zoom>
</view>
</subsheet>
<subsheet subsheetid="4e9c1383-a686-4fbc-9e3c-c11c8ade88af" type="Normal" published="True">
<name>Get CSV File</name>
<view>
<camerax>-3</camerax>
<cameray>61</cameray>
<zoom version="2">1.25</zoom>
</view>
</subsheet>
<subsheet subsheetid="d2d014d5-71ff-47d1-8a2d-adf47aa96ab6" type="Normal" published="True">
<name>Get CSV</name>
<view>
<camerax>-65</camerax>
<cameray>42</cameray>
<zoom version="2">1.25</zoom>
</view>
</subsheet>
<subsheet subsheetid="43d80e10-0a8d-46f4-abcb-19fcbd68fc6b" type="Normal" published="True">
<name>Get User Name</name>
<view>
<camerax>0</camerax>
<cameray>0</cameray>
<zoom version="2">1.25</zoom>
</view>
</subsheet>
<subsheet subsheetid="5c204a77-ccc6-45cd-a3be-936abb251c49" type="Normal" published="True">
<name>Get Machine Name</name>
<view>
<camerax>-103</camerax>
<cameray>0</cameray>
<zoom version="2">1.25</zoom>
</view>
</subsheet>
<subsheet subsheetid="379163bf-d2ab-47d2-9132-1827ccf80e66" type="Normal" published="True">
<name>Delete Rows - Where</name>
<view>
<camerax>0</camerax>
<cameray>21</cameray>
<zoom version="2">1.25</zoom>
</view>
</subsheet>
<subsheet subsheetid="15d519d8-1803-4720-821c-3ccea40d8273" type="Normal" published="True">
<name>Drop Table</name>
<view>
<camerax>7</camerax>
<cameray>10</cameray>
<zoom version="2">1.25</zoom>
</view>
</subsheet>
<subsheet subsheetid="ba1c8e81-ef16-4940-a993-09fe604cda76" type="Normal" published="True">
<name>Truncate Table</name>
<view>
<camerax>7</camerax>
<cameray>-11</cameray>
<zoom version="2">1.25</zoom>
</view>
</subsheet>
<stage stageid="4969a71c-3756-4bdd-93e4-cee02b3f715d" name="Start" type="Start">
<loginhibit />
<onsuccess>3706037c-9ce5-4836-a0bd-3201c0f182b0</onsuccess>
<displayx>15</displayx>
<displayy>-105</displayy>
</stage>
<stage stageid="3706037c-9ce5-4836-a0bd-3201c0f182b0" name="End" type="End">
<loginhibit />
<displayx>15</displayx>
<displayy>90</displayy>
</stage>
<stage stageid="ed8a4788-e843-4ab2-b271-29f6859203b3" name="Stage1" type="ProcessInfo">
<references>
<reference>System.dll</reference>
<reference>System.Data.dll</reference>
<reference>System.Xml.dll</reference>
<reference>System.Drawing.dll</reference>
<reference>Oracle.ManagedDataAccess.dll</reference>
</references>
<imports>
<import>System</import>
<import>System.Drawing</import>
<import>System.Data</import>
<import>Oracle.ManagedDataAccess.Client</import>
<import>System.IO</import>
</imports>
<language>csharp</language>
<globalcode><![CDATA[]]></globalcode>
<code><![CDATA[OracleConnection moConnection;
OracleTransaction moTransaction;
private void WriteCsv(string sql, TextWriter @out)
{
// The target data set
DataSet ds = new DataSet();
// Build and execute the command, dumping the data into the above set
using (OracleCommand cmd = new OracleCommand())
{
cmd.Connection = moConnection;
cmd.Transaction = moTransaction;
cmd.CommandText = sql;
using (OracleDataAdapter da = new OracleDataAdapter())
{
da.SelectCommand = cmd;
da.Fill(ds);
}
}
// Go through the data, escaping and outputting to the writer
char[] quotesRequiredChars = new[] { ',', '"' };
foreach (DataTable tab in ds.Tables)
{
// Column headers first
bool first = true;
foreach (DataColumn col in tab.Columns)
{
if (first)
first = false;
else
@out.Write(",");
string val = col.ColumnName;
if (val.IndexOfAny(quotesRequiredChars) >= 0)
val = "\"" + val.Replace("\"", "\"\"") + "\"";
@out.Write(val);
}
@out.WriteLine();
// Then a line for each row
foreach (DataRow row in tab.Rows)
{
first = true;
foreach (DataColumn col in tab.Columns)
{
if (first)
first = false;
else
@out.Write(",");
if (row.IsNull(col))
continue;
string val = row[col].ToString();
if (val.IndexOfAny(quotesRequiredChars) >= 0)
val = "\"" + val.Replace("\"", "\"\"") + "\"";
@out.Write(val);
}
@out.WriteLine();
}
// Separate each table with a couple of blank lines
@out.WriteLine();
@out.WriteLine();
}
@out.Flush();
}
private T GetScalar<T>(string sql,bool success, string msg)
{
// Assume Success
success = true;
msg = "";
try
{
using (OracleCommand cmd = new OracleCommand())
{
cmd.Connection = moConnection;
cmd.CommandText = sql;
cmd.Transaction = moTransaction;
return (T)(cmd.ExecuteScalar());
}
}
catch (Exception ex)
{
success = false;
msg = ex.Message;
return default(T);
}
}
]]></code>
<displayx>-195</displayx>
<displayy>-105</displayy>
<displaywidth>150</displaywidth>
<displayheight>90</displayheight>
</stage>
<stage stageid="0ef6f368-d507-4312-8046-108a10b69b49" name="Clean Up" type="SubSheetInfo">
<subsheetid>72c790c5-372a-4eb5-804b-5ee825cbdf29</subsheetid>
<displayx>-195</displayx>
<displayy>-105</displayy>
<displaywidth>150</displaywidth>
<displayheight>90</displayheight>
</stage>
<stage stageid="177a890f-c96f-4c74-a4d4-e3809fbbf5a6" name="Start" type="Start">
<subsheetid>72c790c5-372a-4eb5-804b-5ee825cbdf29</subsheetid>
<loginhibit />
<onsuccess>95418068-629d-482e-b6de-2d0700d64324</onsuccess>
<displayx>15</displayx>
<displayy>-105</displayy>
</stage>
<stage stageid="95418068-629d-482e-b6de-2d0700d64324" name="End" type="End">
<subsheetid>72c790c5-372a-4eb5-804b-5ee825cbdf29</subsheetid>
<loginhibit />
<displayx>15</displayx>
<displayy>90</displayy>
</stage>
<stage stageid="04c0596b-001c-49eb-9f3c-887dd601f350" name="Configure" type="SubSheetInfo">
<subsheetid>ccacb83a-6ee1-4fc5-9c2b-d09215a4f561</subsheetid>
<narrative>Configures this instance of the utility VBO. Calling it with no parameters will cause the configuration to be reset to default values.</narrative>
<displayx>-195</displayx>
<displayy>-105</displayy>
<displaywidth>150</displaywidth>
<displayheight>90</displayheight>
</stage>
<stage stageid="1c104840-16a1-496e-ad28-fddb11f9789d" name="Start" type="Start">
<subsheetid>ccacb83a-6ee1-4fc5-9c2b-d09215a4f561</subsheetid>
<loginhibit />
<inputs>
<input type="flag" name="RaiseExceptions" stage="Raise exception on any failure" />
</inputs>
<onsuccess>d3a89de2-7d36-4999-97ce-db033ac7f336</onsuccess>
<displayx>15</displayx>
<displayy>-105</displayy>
</stage>
<stage stageid="d3a89de2-7d36-4999-97ce-db033ac7f336" name="End" type="End">
<subsheetid>ccacb83a-6ee1-4fc5-9c2b-d09215a4f561</subsheetid>
<loginhibit />
<displayx>15</displayx>
<displayy>15</displayy>
</stage>
<stage stageid="a70e3afd-4ed5-4ea0-9da9-78595c402ace" name="Note1" type="Note">
<subsheetid>72c790c5-372a-4eb5-804b-5ee825cbdf29</subsheetid>
<narrative>Clean Up Page
This is an optional page where you might choose to perform some finalisation (or "cleanup") tasks as your business object is closed down.
The cleanup action will be called automatically immediately after closing your business object at the end of a business process.
You will not be able to call this action from a business process, nor will it be called at any other time than before the disposal of the business object.</narrative>
<displayx>-180</displayx>
<displayy>60</displayy>
<displaywidth>180</displaywidth>
<displayheight>230</displayheight>
</stage>
<stage stageid="54c2b660-99cb-4df4-a1ed-cc58945720c5" name="Raise exception on any failure" type="Data">
<subsheetid>ccacb83a-6ee1-4fc5-9c2b-d09215a4f561</subsheetid>
<datatype>flag</datatype>
<initialvalue>False</initialvalue>
<alwaysinit />
<displayx>-195</displayx>
<displayy>-15</displayy>
<displaywidth>180</displaywidth>
<displayheight>30</displayheight>
</stage>
<stage stageid="fe732869-bd80-413d-8263-aaaa6d448daf" name="Raise Exception If Appropriate" type="SubSheetInfo">
<subsheetid>88b62fd7-41a8-4bc7-806a-bd8e1b5497ca</subsheetid>
<narrative>Debugging Tool. Set this variable to true to expose exceptions.</narrative>
<displayx>-195</displayx>
<displayy>-105</displayy>
<displaywidth>150</displaywidth>
<displayheight>60</displayheight>
</stage>
<stage stageid="575a27ef-9b4e-43f8-ba6a-102b863f2ff4" name="Start" type="Start">
<subsheetid>88b62fd7-41a8-4bc7-806a-bd8e1b5497ca</subsheetid>
<loginhibit />
<inputs>
<input type="flag" name="Success" stage="Success" />
<input type="text" name="Error Message" stage="Error Message" />
</inputs>
<onsuccess>93c91ad7-3d15-4d03-bd8b-c883b774d565</onsuccess>
<displayx>15</displayx>
<displayy>-105</displayy>
</stage>
<stage stageid="f37cdc05-bffc-4cd7-bb4a-44256b547d97" name="End" type="End">
<subsheetid>88b62fd7-41a8-4bc7-806a-bd8e1b5497ca</subsheetid>
<loginhibit />
<displayx>15</displayx>
<displayy>30</displayy>
</stage>
<stage stageid="a0961408-d6de-4e2d-9bc9-6e69dfd47028" name="Success" type="Data">
<subsheetid>88b62fd7-41a8-4bc7-806a-bd8e1b5497ca</subsheetid>
<datatype>flag</datatype>
<initialvalue />
<private />
<alwaysinit />
<displayx>-225</displayx>
<displayy>15</displayy>
</stage>
<stage stageid="ec1d2dcb-0ba8-4a75-8904-743d9ac125cb" name="Error Message" type="Data">
<subsheetid>88b62fd7-41a8-4bc7-806a-bd8e1b5497ca</subsheetid>
<datatype>text</datatype>
<initialvalue />
<private />
<alwaysinit />
<displayx>-165</displayx>
<displayy>15</displayy>
</stage>
<stage stageid="93c91ad7-3d15-4d03-bd8b-c883b774d565" name="Should Raise Exception" type="Decision">
<subsheetid>88b62fd7-41a8-4bc7-806a-bd8e1b5497ca</subsheetid>
<loginhibit />
<decision expression="[Success] = False AND [Raise exception on any failure]" />
<ontrue>27775845-b030-4aa2-b505-f7eff110fda6</ontrue>
<onfalse>f37cdc05-bffc-4cd7-bb4a-44256b547d97</onfalse>
<displayx>15</displayx>
<displayy>-45</displayy>
<displaywidth>90</displaywidth>
<displayheight>60</displayheight>
</stage>
<stage stageid="27775845-b030-4aa2-b505-f7eff110fda6" name="Fail" type="Exception">
<subsheetid>88b62fd7-41a8-4bc7-806a-bd8e1b5497ca</subsheetid>
<exception localized="yes" type="Action Failed" detail="[Error Message]" />
<displayx>120</displayx>
<displayy>-45</displayy>
</stage>
<stage stageid="1a1ad7fa-2462-440c-a88c-2f95b920aed0" name="Set Connection" type="SubSheetInfo">
<subsheetid>241b279e-d44c-422b-9421-669b95323468</subsheetid>
<narrative>This function configures the connection string if it doesn't exist. The connectionstring data item is a shared data item and can be found on the Initialise page.</narrative>
<displayx>-195</displayx>
<displayy>-105</displayy>
<displaywidth>150</displaywidth>
<displayheight>90</displayheight>
</stage>
<stage stageid="31106dda-a3ac-427e-ac76-4fcac47e00ab" name="Start" type="Start">
<subsheetid>241b279e-d44c-422b-9421-669b95323468</subsheetid>
<loginhibit />
<inputs>
<input type="text" name="ConnectionName" stage="OracleMDA_SID" />
<input type="text" name="Hostname" narrative="The IP address of the oracle host." stage="OracleMDA_Host" />
<input type="text" name="Port" narrative="The listening port on the oracle host." stage="OracleMDA_Port" />
<input type="text" name="Username" stage="User" />
<input type="password" name="Password" stage="Password" />
</inputs>
<onsuccess>23379fc1-8199-40a0-b60c-a144ffe2411d</onsuccess>
<displayx>15</displayx>
<displayy>-105</displayy>
</stage>
<stage stageid="63eec0fc-57a8-443e-88e3-353595c7ab73" name="End" type="End">
<subsheetid>241b279e-d44c-422b-9421-669b95323468</subsheetid>
<loginhibit />
<outputs>
<output type="text" name="ConnectionString" stage="Connection String" />
</outputs>
<displayx>15</displayx>
<displayy>195</displayy>
</stage>
<stage stageid="dd63f0d3-c657-41c9-ae21-8c87a491a75b" name="Close Success" type="Data">
<subsheetid>241b279e-d44c-422b-9421-669b95323468</subsheetid>
<datatype>flag</datatype>
<initialvalue />
<private />
<alwaysinit />
<displayx>-195</displayx>
<displayy>-15</displayy>
<displaywidth>90</displaywidth>
<displayheight>30</displayheight>
</stage>
<stage stageid="d4b6a8d1-3b79-4e2f-b13e-417ac0f57c3f" name="Close Message" type="Data">
<subsheetid>241b279e-d44c-422b-9421-669b95323468</subsheetid>
<datatype>text</datatype>
<initialvalue />
<private />
<alwaysinit />
<displayx>-195</displayx>
<displayy>15</displayy>
<displaywidth>90</displaywidth>
<displayheight>30</displayheight>
</stage>
<stage stageid="e4e13c66-26c7-448f-8e61-b1fe55caf4f1" name="OracleMDA_SID" type="Data">
<loginhibit />
<narrative>The connection name as used in SQL Developer.</narrative>
<datatype>text</datatype>
<initialvalue />
<displayx>180</displayx>
<displayy>-165</displayy>
<displaywidth>180</displaywidth>
<displayheight>30</displayheight>
</stage>
<stage stageid="330b137c-4139-4d09-8536-fe9ce16a7c5c" name="OracleMDA_Host" type="Data">
<loginhibit />
<narrative>The IP address of the computer that is hosting the Oracle RDBMS</narrative>
<datatype>text</datatype>
<initialvalue />
<displayx>180</displayx>
<displayy>-120</displayy>
<displaywidth>180</displaywidth>
<displayheight>30</displayheight>
</stage>
<stage stageid="e61ffe55-2080-4c8b-bf5c-0115dd94c3a6" name="User" type="Data">
<loginhibit />
<datatype>text</datatype>
<initialvalue />
<displayx>180</displayx>
<displayy>-75</displayy>
<displaywidth>180</displaywidth>
<displayheight>30</displayheight>
</stage>
<stage stageid="271d596a-eb99-4605-b397-3ef6fac37f02" name="Password" type="Data">
<loginhibit />
<datatype>password</datatype>
<initialvalueenc></initialvalueenc>
<displayx>180</displayx>
<displayy>30</displayy>
<displaywidth>180</displaywidth>
<displayheight>30</displayheight>
</stage>
<stage stageid="958d224f-337d-4844-95ef-d949e591a532" name="Connection String" type="Data">
<loginhibit />
<datatype>text</datatype>
<initialvalue />
<displayx>180</displayx>
<displayy>75</displayy>
<displaywidth>180</displaywidth>
<displayheight>30</displayheight>
</stage>
<stage stageid="9bcda1a2-6dbd-405e-bab8-c87c569650f4" name="Records Affected" type="Data">
<loginhibit />
<datatype>number</datatype>
<initialvalue>0</initialvalue>
<displayx>180</displayx>
<displayy>135</displayy>
<displaywidth>180</displaywidth>
<displayheight>30</displayheight>
</stage>
<stage stageid="51afb2e4-d650-4b57-bd3f-6b95238dcb61" name="In Transaction" type="Data">
<loginhibit />
<datatype>flag</datatype>
<initialvalue>False</initialvalue>
<displayx>180</displayx>
<displayy>180</displayy>
<displaywidth>180</displaywidth>
<displayheight>30</displayheight>
</stage>
<stage stageid="bee8e60a-ac84-4447-8a09-7a61172b7f64" name="Closing" type="Data">
<loginhibit />
<narrative>Flag indicating that the connection wrapped by this VBO is currently in the process of closing</narrative>
<datatype>flag</datatype>
<initialvalue>False</initialvalue>
<alwaysinit />
<displayx>180</displayx>
<displayy>225</displayy>
<displaywidth>180</displaywidth>
<displayheight>30</displayheight>
</stage>
<stage stageid="23379fc1-8199-40a0-b60c-a144ffe2411d" name="Connection String already set?" type="Decision">
<subsheetid>241b279e-d44c-422b-9421-669b95323468</subsheetid>
<loginhibit />
<decision expression="[Connection String]&lt;&gt;&quot;&quot;" />
<ontrue>c7de8c51-e623-4f7d-abc0-5ae060147a49</ontrue>
<onfalse>8cc10863-aadb-43f0-a893-ab9f338af9eb</onfalse>
<displayx>15</displayx>
<displayy>-45</displayy>
<displaywidth>120</displaywidth>
<displayheight>30</displayheight>
</stage>
<stage stageid="6411380e-6a99-446f-9285-2a0143854c4f" name="User Set?" type="Decision">
<subsheetid>241b279e-d44c-422b-9421-669b95323468</subsheetid>
<loginhibit />
<decision expression="[User]&lt;&gt; &quot;&quot;" />
<ontrue>a3642585-8c94-47f7-9057-3080785bf368</ontrue>
<onfalse>e0942963-e085-4d12-851e-f1909dec741e</onfalse>
<displayx>15</displayx>
<displayy>60</displayy>
</stage>
<stage stageid="8cc10863-aadb-43f0-a893-ab9f338af9eb" name="Anchor1" type="Anchor">
<subsheetid>241b279e-d44c-422b-9421-669b95323468</subsheetid>
<loginhibit />
<onsuccess>6411380e-6a99-446f-9285-2a0143854c4f</onsuccess>
<displayx>15</displayx>
<displayy>15</displayy>
<displaywidth>10</displaywidth>
<displayheight>10</displayheight>
</stage>
<stage stageid="a3642585-8c94-47f7-9057-3080785bf368" name="Anchor2" type="Anchor">
<subsheetid>241b279e-d44c-422b-9421-669b95323468</subsheetid>
<loginhibit />
<onsuccess>dfa48d56-299e-404b-882a-c924299e9968</onsuccess>
<displayx>-45</displayx>
<displayy>60</displayy>
<displaywidth>10</displaywidth>
<displayheight>10</displayheight>
</stage>
<stage stageid="e0942963-e085-4d12-851e-f1909dec741e" name="Anchor3" type="Anchor">
<subsheetid>241b279e-d44c-422b-9421-669b95323468</subsheetid>
<loginhibit />
<onsuccess>d4784445-e461-42b9-8324-8e6cebd6fac9</onsuccess>
<displayx>75</displayx>
<displayy>60</displayy>
<displaywidth>10</displaywidth>
<displayheight>10</displayheight>
</stage>
<stage stageid="dfa48d56-299e-404b-882a-c924299e9968" name="Set Connection" type="Calculation">
<subsheetid>241b279e-d44c-422b-9421-669b95323468</subsheetid>
<loginhibit />
<onsuccess>1054a4ca-66c5-4bbd-b2c7-6c2db1803206</onsuccess>
<calculation expression="&quot;Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=&quot; &amp; [OracleMDA_Host] &amp;&quot;)(PORT=&quot; &amp; [OracleMDA_Port] &amp; &quot;))(CONNECT_DATA=(SERVICE_NAME=&quot; &amp; [OracleMDA_SID] &amp; &quot;)));User Id=&quot; &amp; [User] &amp; &quot;;Password=&quot; &amp; [Password] &amp; &quot;;&quot;&#xA;&#xA;" stage="Connection String" />
<displayx>-45</displayx>
<displayy>105</displayy>
</stage>
<stage stageid="d4784445-e461-42b9-8324-8e6cebd6fac9" name="Set Connection" type="Calculation">
<subsheetid>241b279e-d44c-422b-9421-669b95323468</subsheetid>
<loginhibit />
<onsuccess>30c57d5f-e547-4f10-8b4f-c721a474027a</onsuccess>
<calculation expression="&quot;Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=&quot; &amp; [OracleMDA_Host] &amp;&quot;)(PORT=&quot; &amp; [OracleMDA_Port] &amp; &quot;))(CONNECT_DATA=(SERVICE_NAME=&quot; &amp; [OracleMDA_SID] &amp; &quot;)));Integrated Security=yes;&quot;" stage="Connection String" />
<displayx>75</displayx>
<displayy>105</displayy>
</stage>
<stage stageid="1054a4ca-66c5-4bbd-b2c7-6c2db1803206" name="Anchor4" type="Anchor">
<subsheetid>241b279e-d44c-422b-9421-669b95323468</subsheetid>
<loginhibit />
<onsuccess>63eec0fc-57a8-443e-88e3-353595c7ab73</onsuccess>
<displayx>-45</displayx>
<displayy>195</displayy>
<displaywidth>10</displaywidth>
<displayheight>10</displayheight>
</stage>
<stage stageid="30c57d5f-e547-4f10-8b4f-c721a474027a" name="Anchor5" type="Anchor">
<subsheetid>241b279e-d44c-422b-9421-669b95323468</subsheetid>
<loginhibit />
<onsuccess>63eec0fc-57a8-443e-88e3-353595c7ab73</onsuccess>
<displayx>75</displayx>
<displayy>195</displayy>
<displaywidth>10</displaywidth>
<displayheight>10</displayheight>
</stage>
<stage stageid="12140228-748e-459c-9906-b34af2de7d77" name="Internal Close" type="SubSheetInfo">
<subsheetid>f64b457a-dfb7-4200-9a9f-5dd147561478</subsheetid>
<narrative>This is an internally used class for opening the connection. It is not published for use in processes.</narrative>
<displayx>-195</displayx>
<displayy>-105</displayy>
<displaywidth>150</displaywidth>
<displayheight>90</displayheight>
</stage>
<stage stageid="b4b5d985-b314-4f79-88fc-e816aeb96216" name="Start" type="Start">
<subsheetid>f64b457a-dfb7-4200-9a9f-5dd147561478</subsheetid>
<loginhibit />
<inputs>
<input type="flag" name="Clear Pool" stage="Clear Pool" />
</inputs>
<onsuccess>3267a4fd-49b5-4073-991d-54c06427cefa</onsuccess>
<displayx>15</displayx>
<displayy>-135</displayy>
</stage>
<stage stageid="300588fc-175b-4f38-bb7f-6045a221374a" name="End" type="End">
<subsheetid>f64b457a-dfb7-4200-9a9f-5dd147561478</subsheetid>
<loginhibit />
<outputs>
<output type="flag" name="Success" stage="Success" />
<output type="text" name="Message" stage="Message" />
</outputs>
<displayx>15</displayx>
<displayy>285</displayy>
</stage>
<stage stageid="abd3ec34-0739-4a78-816c-a307bb7f7719" name="Internal Close" type="SubSheet">
<subsheetid>241b279e-d44c-422b-9421-669b95323468</subsheetid>
<loginhibit />
<inputs>
<input type="flag" name="Clear Pool" friendlyname="Clear Pool" expr="False" />
</inputs>
<outputs>
<output type="flag" name="Success" friendlyname="Success" stage="Close Success" />
<output type="text" name="Message" friendlyname="Message" stage="Close Message" />
</outputs>
<onsuccess>8cc10863-aadb-43f0-a893-ab9f338af9eb</onsuccess>
<processid>f64b457a-dfb7-4200-9a9f-5dd147561478</processid>
<displayx>165</displayx>
<displayy>15</displayy>
</stage>
<stage stageid="3267a4fd-49b5-4073-991d-54c06427cefa" name="Already Closing?" type="Decision">
<subsheetid>f64b457a-dfb7-4200-9a9f-5dd147561478</subsheetid>
<loginhibit />
<decision expression="[Closing]" />
<ontrue>836602a9-c431-4003-9114-b1781b79f736</ontrue>
<onfalse>2b679340-4669-481d-a262-513ad5503884</onfalse>
<displayx>15</displayx>
<displayy>-75</displayy>
</stage>
<stage stageid="2b679340-4669-481d-a262-513ad5503884" name="Closing := True" type="Calculation">
<subsheetid>f64b457a-dfb7-4200-9a9f-5dd147561478</subsheetid>
<loginhibit />
<onsuccess>bdb2e204-909b-4eec-a5b3-d7e001bce6ef</onsuccess>
<calculation expression="True" stage="Closing" />
<displayx>15</displayx>
<displayy>-15</displayy>
<displaywidth>90</displaywidth>
<displayheight>30</displayheight>
</stage>
<stage stageid="bdb2e204-909b-4eec-a5b3-d7e001bce6ef" name="In A Transaction?" type="Decision">
<subsheetid>f64b457a-dfb7-4200-9a9f-5dd147561478</subsheetid>
<loginhibit />
<decision expression="[In Transaction]=True" />
<ontrue>3f13478d-668e-4544-9cfd-1a33770ee2f1</ontrue>
<onfalse>e4b79dd3-f709-42da-a7b1-70d9fd212f98</onfalse>
<displayx>15</displayx>
<displayy>45</displayy>
</stage>
<stage stageid="90693e98-ea99-4135-8cdc-e96c50698741" name="Success" type="Data">
<subsheetid>f64b457a-dfb7-4200-9a9f-5dd147561478</subsheetid>
<loginhibit />
<datatype>flag</datatype>
<initialvalue>False</initialvalue>
<private />
<alwaysinit />
<displayx>-195</displayx>
<displayy>-15</displayy>
<displaywidth>90</displaywidth>
<displayheight>30</displayheight>
</stage>
<stage stageid="ed7f367f-2af3-425b-bed2-034b32143f7e" name="Message" type="Data">
<subsheetid>f64b457a-dfb7-4200-9a9f-5dd147561478</subsheetid>
<loginhibit />
<datatype>text</datatype>
<initialvalue />
<private />
<alwaysinit />
<displayx>-195</displayx>
<displayy>30</displayy>
<displaywidth>90</displaywidth>
<displayheight>30</displayheight>
</stage>
<stage stageid="bc045fb4-8241-46cc-a374-e87d699af872" name="Clear Pool" type="Data">
<subsheetid>f64b457a-dfb7-4200-9a9f-5dd147561478</subsheetid>
<datatype>flag</datatype>
<initialvalue>True</initialvalue>
<private />
<alwaysinit />
<displayx>-195</displayx>
<displayy>105</displayy>
<displaywidth>90</displaywidth>
<displayheight>30</displayheight>
</stage>
<stage stageid="f7044776-05db-4423-92de-da32d106032b" name="Rollback Transaction" type="SubSheetInfo">
<subsheetid>fe9fac62-8a9a-4b7d-846c-418f73082557</subsheetid>
<narrative>This stage compliments the Begin/Commit Transaction as it allows the database to be returned to the stage prior to the commencement of the Begin Transaction. This would be the case should appropriate conditions or an exception occur.</narrative>
<displayx>-195</displayx>
<displayy>-105</displayy>
<displaywidth>150</displaywidth>
<displayheight>90</displayheight>
</stage>
<stage stageid="e03f0154-b2e8-4af5-9213-6affa5ffea3e" name="Start" type="Start">
<subsheetid>fe9fac62-8a9a-4b7d-846c-418f73082557</subsheetid>
<loginhibit />
<onsuccess>d14fe624-99d5-400b-b824-5dabd803c1d5</onsuccess>
<displayx>15</displayx>
<displayy>-180</displayy>
</stage>
<stage stageid="0982e856-5781-4c2b-8a93-6e1730a9e303" name="End" type="End">
<subsheetid>fe9fac62-8a9a-4b7d-846c-418f73082557</subsheetid>
<loginhibit />
<outputs>
<output type="flag" name="Success" stage="Success" />
<output type="text" name="Message" stage="Message" />
</outputs>
<displayx>15</displayx>
<displayy>180</displayy>
</stage>
<stage stageid="3f13478d-668e-4544-9cfd-1a33770ee2f1" name="Rollback Transaction" type="SubSheet">
<subsheetid>f64b457a-dfb7-4200-9a9f-5dd147561478</subsheetid>
<loginhibit />
<outputs>
<output type="flag" name="Success" friendlyname="Success" stage="Success" />
<output type="text" name="Message" friendlyname="Message" stage="Message" />
</outputs>
<onsuccess>2c124765-5fe1-4dd4-931e-3c35177b8fc0</onsuccess>
<processid>fe9fac62-8a9a-4b7d-846c-418f73082557</processid>
<displayx>15</displayx>
<displayy>105</displayy>
</stage>
<stage stageid="835caf26-6c58-49e3-9ba7-c148725d9032" name="Block1" type="Block">
<subsheetid>f64b457a-dfb7-4200-9a9f-5dd147561478</subsheetid>
<loginhibit />
<font family="Segoe UI" size="10" style="Regular" color="7FB2E5" />
<displayx>-30</displayx>
<displayy>75</displayy>
<displaywidth>180</displaywidth>
<displayheight>60</displayheight>
</stage>
<stage stageid="4044d9e8-48a5-4788-8a34-3d23ac101e09" name="Ignore" type="Recover">
<subsheetid>f64b457a-dfb7-4200-9a9f-5dd147561478</subsheetid>
<loginhibit />
<onsuccess>f2f31bb0-4ee8-418b-8b8f-5425de848229</onsuccess>
<displayx>105</displayx>
<displayy>105</displayy>
</stage>
<stage stageid="f2f31bb0-4ee8-418b-8b8f-5425de848229" name=" " type="Resume">
<subsheetid>f64b457a-dfb7-4200-9a9f-5dd147561478</subsheetid>
<loginhibit />
<onsuccess>2c124765-5fe1-4dd4-931e-3c35177b8fc0</onsuccess>
<displayx>105</displayx>
<displayy>165</displayy>
</stage>
<stage stageid="2c124765-5fe1-4dd4-931e-3c35177b8fc0" name="Close" type="Code">
<subsheetid>f64b457a-dfb7-4200-9a9f-5dd147561478</subsheetid>
<loginhibit />
<inputs>
<input type="flag" name="clearPool" expr="[Clear Pool]" />
<input type="text" name="connString" expr="[Connection String]" />
</inputs>
<outputs>
<output type="flag" name="Success" stage="Success" />
<output type="text" name="Message" stage="Message" />
</outputs>
<onsuccess>3f894655-dcd0-4539-945b-52878a424515</onsuccess>
<code><![CDATA[
Success = true;
Message = "";
try
{
// If we're clearing the pool, we need a
// connection so that we can specify the pool
// we want to clear, so, somewhat obscenely,
// we must create a connection if one does not
// currently exist. Then close it immediately
if (clearPool)
{
if (moConnection != null)
{
moConnection = new OracleConnection(connString);
OracleConnection.ClearPool(moConnection);
}
if (moConnection != null)
{
moConnection.Close();
moConnection.Dispose();
moConnection = null;
}
}
}
catch (Exception ex)
{
Success = false;
Message = ex.Message;
}
]]></code>
<displayx>15</displayx>
<displayy>165</displayy>
</stage>
<stage stageid="3f894655-dcd0-4539-945b-52878a424515" name="Closing:=False" type="Calculation">
<subsheetid>f64b457a-dfb7-4200-9a9f-5dd147561478</subsheetid>
<loginhibit />
<onsuccess>300588fc-175b-4f38-bb7f-6045a221374a</onsuccess>
<calculation expression="False" stage="Closing" />
<displayx>15</displayx>
<displayy>225</displayy>
</stage>
<stage stageid="e4b79dd3-f709-42da-a7b1-70d9fd212f98" name="Anchor6" type="Anchor">
<subsheetid>f64b457a-dfb7-4200-9a9f-5dd147561478</subsheetid>
<loginhibit />
<onsuccess>7a4679e9-e0aa-4de6-b118-453f9472fd05</onsuccess>
<displayx>-45</displayx>
<displayy>45</displayy>
<displaywidth>10</displaywidth>
<displayheight>10</displayheight>
</stage>
<stage stageid="7a4679e9-e0aa-4de6-b118-453f9472fd05" name="Anchor7" type="Anchor">
<subsheetid>f64b457a-dfb7-4200-9a9f-5dd147561478</subsheetid>
<loginhibit />
<onsuccess>2c124765-5fe1-4dd4-931e-3c35177b8fc0</onsuccess>
<displayx>-45</displayx>
<displayy>165</displayy>
<displaywidth>10</displaywidth>
<displayheight>10</displayheight>
</stage>
<stage stageid="836602a9-c431-4003-9114-b1781b79f736" name="Note2" type="Note">
<subsheetid>f64b457a-dfb7-4200-9a9f-5dd147561478</subsheetid>
<loginhibit />
<narrative>Ensure that we're not being called by 'Rollback' which was called by this action - infinite loops are bad.</narrative>
<onsuccess>ac9693d7-26c8-438f-be10-5c79eeb4d641</onsuccess>
<displayx>165</displayx>
<displayy>-75</displayy>
<displaywidth>150</displaywidth>
<displayheight>60</displayheight>
</stage>
<stage stageid="ac9693d7-26c8-438f-be10-5c79eeb4d641" name="Anchor8" type="Anchor">
<subsheetid>f64b457a-dfb7-4200-9a9f-5dd147561478</subsheetid>
<loginhibit />
<onsuccess>300588fc-175b-4f38-bb7f-6045a221374a</onsuccess>
<displayx>165</displayx>
<displayy>285</displayy>
<displaywidth>10</displaywidth>
<displayheight>10</displayheight>
</stage>
<stage stageid="ae7dea42-5e63-443e-8e87-171ed3230cfc" name="Note1" type="Note">
<subsheetid>f64b457a-dfb7-4200-9a9f-5dd147561478</subsheetid>
<loginhibit />
<narrative>Note that we don't throw an exception here even if a failure is encountered - this is probably being called as part of a wider action, and the caller has the context with which to decide where the exception should be raised.</narrative>
<displayx>-165</displayx>
<displayy>270</displayy>
<displaywidth>270</displaywidth>
<displayheight>60</displayheight>
</stage>
<stage stageid="d14fe624-99d5-400b-b824-5dabd803c1d5" name="In Transaction?" type="Decision">
<subsheetid>fe9fac62-8a9a-4b7d-846c-418f73082557</subsheetid>
<loginhibit />
<decision expression="[In Transaction]=True" />
<ontrue>73031632-58af-4fe7-9bfc-a12ba15e4f64</ontrue>
<onfalse>d40038be-a67f-44ef-82ab-a69517948586</onfalse>
<displayx>15</displayx>
<displayy>-120</displayy>
</stage>
<stage stageid="d40038be-a67f-44ef-82ab-a69517948586" name="Error Message" type="Calculation">
<subsheetid>fe9fac62-8a9a-4b7d-846c-418f73082557</subsheetid>
<loginhibit />
<onsuccess>bdb1c15d-229b-49f2-8842-7a8979400deb</onsuccess>
<calculation expression="&quot;There is no open transaction to rollback&quot;" stage="Message" />
<displayx>-75</displayx>
<displayy>-120</displayy>
</stage>
<stage stageid="73031632-58af-4fe7-9bfc-a12ba15e4f64" name="Rollback Transaction" type="Code">
<subsheetid>fe9fac62-8a9a-4b7d-846c-418f73082557</subsheetid>
<loginhibit />
<outputs>
<output type="flag" name="Success" stage="Success" />
<output type="text" name="Message" stage="Message" />
</outputs>
<onsuccess>6acea178-83ac-4b1d-8416-93b4448ac02f</onsuccess>
<code><![CDATA[
Success = true;
Message = "";
try
{
moTransaction.Rollback();
moTransaction = null;
}
catch (Exception ex)
{
Success = false;
Message = ex.Message;
}
]]></code>
<displayx>15</displayx>
<displayy>-60</displayy>
<displaywidth>120</displaywidth>
<displayheight>30</displayheight>
</stage>
<stage stageid="e6a28831-5928-43cd-bbb2-6b23f74c8cb3" name="Success" type="Data">
<subsheetid>fe9fac62-8a9a-4b7d-846c-418f73082557</subsheetid>
<loginhibit />
<datatype>flag</datatype>
<initialvalue>False</initialvalue>
<private />
<alwaysinit />
<displayx>-195</displayx>
<displayy>-15</displayy>
<displaywidth>90</displaywidth>
<displayheight>30</displayheight>
</stage>
<stage stageid="0225edc5-4e27-44af-8c06-36c7ed21a9a1" name="Message" type="Data">
<subsheetid>fe9fac62-8a9a-4b7d-846c-418f73082557</subsheetid>
<loginhibit />
<datatype>text</datatype>
<initialvalue />
<private />
<alwaysinit />
<displayx>-195</displayx>
<displayy>30</displayy>
<displaywidth>90</displaywidth>
<displayheight>30</displayheight>
</stage>
<stage stageid="50266728-3a96-46e7-8248-3c8cc7deba41" name="Close Success" type="Data">
<subsheetid>fe9fac62-8a9a-4b7d-846c-418f73082557</subsheetid>
<datatype>flag</datatype>
<initialvalue />
<private />
<alwaysinit />
<displayx>-225</displayx>
<displayy>120</displayy>
</stage>
<stage stageid="73f64c38-e359-40ed-bf69-4ce52fdd0a13" name="Close Message" type="Data">
<subsheetid>fe9fac62-8a9a-4b7d-846c-418f73082557</subsheetid>
<datatype>text</datatype>
<initialvalue />
<private />
<alwaysinit />
<displayx>-165</displayx>
<displayy>120</displayy>
</stage>
<stage stageid="6acea178-83ac-4b1d-8416-93b4448ac02f" name="Not In Transaction" type="Calculation">
<subsheetid>fe9fac62-8a9a-4b7d-846c-418f73082557</subsheetid>
<loginhibit />
<onsuccess>a3561b5a-70ba-4972-8d75-8ec7870355d7</onsuccess>
<calculation expression="False" stage="In Transaction" />
<displayx>15</displayx>
<displayy>0</displayy>
</stage>
<stage stageid="a3561b5a-70ba-4972-8d75-8ec7870355d7" name="Internal Close" type="SubSheet">
<subsheetid>fe9fac62-8a9a-4b7d-846c-418f73082557</subsheetid>
<loginhibit />
<inputs>
<input type="flag" name="Clear Pool" friendlyname="Clear Pool" expr="False" />
</inputs>
<outputs>
<output type="flag" name="Success" friendlyname="Success" stage="Close Success" />
<output type="text" name="Message" friendlyname="Message" stage="Close Message" />
</outputs>
<onsuccess>29e41eea-0feb-4bd6-8454-64ef8c97bfb2</onsuccess>
<processid>f64b457a-dfb7-4200-9a9f-5dd147561478</processid>
<displayx>15</displayx>
<displayy>60</displayy>
</stage>
<stage stageid="29e41eea-0feb-4bd6-8454-64ef8c97bfb2" name="Raise Exception If Appropriate" type="SubSheet">
<subsheetid>fe9fac62-8a9a-4b7d-846c-418f73082557</subsheetid>
<loginhibit />
<inputs>
<input type="flag" name="Success" friendlyname="Success" expr="[Success]" />
<input type="text" name="Error Message" friendlyname="Error Message" expr="[Message]" />
</inputs>
<onsuccess>0982e856-5781-4c2b-8a93-6e1730a9e303</onsuccess>
<processid>88b62fd7-41a8-4bc7-806a-bd8e1b5497ca</processid>
<displayx>15</displayx>
<displayy>120</displayy>
</stage>
<stage stageid="bdb1c15d-229b-49f2-8842-7a8979400deb" name="Anchor9" type="Anchor">
<subsheetid>fe9fac62-8a9a-4b7d-846c-418f73082557</subsheetid>
<loginhibit />
<onsuccess>a3561b5a-70ba-4972-8d75-8ec7870355d7</onsuccess>
<displayx>-75</displayx>
<displayy>60</displayy>
<displaywidth>10</displaywidth>
<displayheight>10</displayheight>
</stage>
<stage stageid="d2ab8f49-a0f4-4a31-ba69-943a59e0e016" name="Open" type="SubSheetInfo">
<subsheetid>d7f92fab-b3c7-4c06-ae2d-503e20b73fd7</subsheetid>
<narrative>This is an internally used class for opening the connection. It is not published for use in processes.</narrative>
<displayx>-195</displayx>
<displayy>-105</displayy>
<displaywidth>150</displaywidth>
<displayheight>90</displayheight>
</stage>
<stage stageid="2c490ca4-70b1-4237-ae01-1119a7a6dace" name="Start" type="Start">
<subsheetid>d7f92fab-b3c7-4c06-ae2d-503e20b73fd7</subsheetid>
<loginhibit />
<onsuccess>00698ea1-1f54-4ff3-b569-095808fbd9b0</onsuccess>
<displayx>15</displayx>
<displayy>-105</displayy>
</stage>
<stage stageid="b6156a37-fe0b-4731-b6b2-acc5c38f55b6" name="End" type="End">
<subsheetid>d7f92fab-b3c7-4c06-ae2d-503e20b73fd7</subsheetid>
<loginhibit />
<outputs>
<output type="flag" name="Success" stage="Success" />
<output type="text" name="Message" stage="Message" />
</outputs>
<displayx>15</displayx>
<displayy>135</displayy>
</stage>
<stage stageid="39791382-70fd-42b9-9ee6-829d004e1cc4" name="Success" type="Data">
<subsheetid>d7f92fab-b3c7-4c06-ae2d-503e20b73fd7</subsheetid>
<loginhibit />
<datatype>flag</datatype>
<initialvalue>False</initialvalue>
<private />
<alwaysinit />
<displayx>-195</displayx>
<displayy>-15</displayy>
<displaywidth>90</displaywidth>
<displayheight>30</displayheight>
</stage>
<stage stageid="80239b1f-5867-47a3-be4b-66c0da97fe11" name="Message" type="Data">
<subsheetid>d7f92fab-b3c7-4c06-ae2d-503e20b73fd7</subsheetid>
<loginhibit />
<datatype>text</datatype>
<initialvalue />
<private />
<alwaysinit />
<displayx>-195</displayx>
<displayy>30</displayy>
<displaywidth>90</displaywidth>
<displayheight>30</displayheight>
</stage>
<stage stageid="19556310-2b41-422d-af21-e3c6458d1dfe" name="Open" type="Code">
<subsheetid>d7f92fab-b3c7-4c06-ae2d-503e20b73fd7</subsheetid>
<loginhibit />
<inputs>
<input type="text" name="ConnectionString" expr="[Connection String]" />
</inputs>
<outputs>
<output type="flag" name="Success" stage="Success" />
<output type="text" name="Message" stage="Message" />
</outputs>
<onsuccess>b69b3d4c-31fa-4200-bc51-6ba91231f505</onsuccess>
<code><![CDATA[Success = true;
Message = "";
if (moConnection != null) return ;
try
{
moConnection = new OracleConnection(ConnectionString);
moConnection.Open();
}
catch (Exception ex)
{
Success = false;
Message = ex.Message;
}]]></code>
<displayx>15</displayx>
<displayy>15</displayy>
</stage>
<stage stageid="b69b3d4c-31fa-4200-bc51-6ba91231f505" name="Raise Exception If Appropriate" type="SubSheet">
<subsheetid>d7f92fab-b3c7-4c06-ae2d-503e20b73fd7</subsheetid>
<loginhibit />
<inputs>
<input type="flag" name="Success" friendlyname="Success" expr="[Success]" />
<input type="text" name="Error Message" friendlyname="Error Message" expr="[Message]" />
</inputs>
<onsuccess>b6156a37-fe0b-4731-b6b2-acc5c38f55b6</onsuccess>
<processid>88b62fd7-41a8-4bc7-806a-bd8e1b5497ca</processid>
<displayx>15</displayx>
<displayy>75</displayy>
</stage>
<stage stageid="780cd70c-f0b0-453b-a7b8-a01a271fedda" name="OracleMDA_Port" type="Data">
<loginhibit />
<datatype>text</datatype>
<initialvalue />
<displayx>180</displayx>
<displayy>-30</displayy>
<displaywidth>180</displaywidth>
<displayheight>30</displayheight>
</stage>
<stage stageid="c7de8c51-e623-4f7d-abc0-5ae060147a49" name="Note3" type="Note">
<subsheetid>241b279e-d44c-422b-9421-669b95323468</subsheetid>
<loginhibit />
<narrative>Close and clear the connection pool</narrative>
<onsuccess>abd3ec34-0739-4a78-816c-a307bb7f7719</onsuccess>
<displayx>165</displayx>
<displayy>-45</displayy>
<displaywidth>120</displaywidth>
<displayheight>30</displayheight>
</stage>
<stage stageid="0a6e2c3a-562c-40da-98b6-3d8a8f02779c" name="Close" type="SubSheetInfo">
<subsheetid>3a8c9643-d2ff-4ff3-a035-cde16e518ba8</subsheetid>
<narrative>This is an internally used class for opening the connection. It is not published for use in processes.</narrative>
<displayx>-195</displayx>
<displayy>-105</displayy>
<displaywidth>150</displaywidth>
<displayheight>90</displayheight>
</stage>
<stage stageid="87c6c743-9a7b-4fc1-9ca5-a5f3142b07a9" name="Start" type="Start">
<subsheetid>3a8c9643-d2ff-4ff3-a035-cde16e518ba8</subsheetid>
<loginhibit />
<onsuccess>0c0a96fe-7d9a-4fb6-b233-bb9d5fa7db9b</onsuccess>
<displayx>15</displayx>
<displayy>-105</displayy>
</stage>
<stage stageid="5a003f93-de9d-45b7-b880-bebc46f8038d" name="End" type="End">
<subsheetid>3a8c9643-d2ff-4ff3-a035-cde16e518ba8</subsheetid>
<loginhibit />
<outputs>
<output type="flag" name="Success" stage="Success" />
<output type="text" name="Message" stage="Message" />
</outputs>
<displayx>15</displayx>
<displayy>15</displayy>
</stage>
<stage stageid="216ed3bb-6e7e-47c9-bdc0-c30b93cedeeb" name="Success" type="Data">
<subsheetid>3a8c9643-d2ff-4ff3-a035-cde16e518ba8</subsheetid>
<datatype>flag</datatype>
<initialvalue />
<private />
<alwaysinit />
<displayx>-195</displayx>
<displayy>-30</displayy>
</stage>
<stage stageid="74e41c4e-a95d-4a51-ab4b-f3ff10121e5c" name="Message" type="Data">
<subsheetid>3a8c9643-d2ff-4ff3-a035-cde16e518ba8</subsheetid>
<datatype>text</datatype>
<initialvalue />
<private />
<alwaysinit />
<displayx>-195</displayx>
<displayy>15</displayy>
</stage>
<stage stageid="0c0a96fe-7d9a-4fb6-b233-bb9d5fa7db9b" name="Internal Close" type="SubSheet">
<subsheetid>3a8c9643-d2ff-4ff3-a035-cde16e518ba8</subsheetid>
<loginhibit />
<inputs>
<input type="flag" name="Clear Pool" friendlyname="Clear Pool" expr="False" />
</inputs>
<outputs>
<output type="flag" name="Success" friendlyname="Success" stage="Success" />
<output type="text" name="Message" friendlyname="Message" stage="Message" />
</outputs>
<onsuccess>5a003f93-de9d-45b7-b880-bebc46f8038d</onsuccess>
<processid>f64b457a-dfb7-4200-9a9f-5dd147561478</processid>
<displayx>15</displayx>
<displayy>-45</displayy>
</stage>
<stage stageid="061526fd-9a49-4011-9e7f-b0521c844260" name="Is Open" type="SubSheetInfo">
<subsheetid>ea43971d-49fa-4f4e-9f46-9fc8bc6135b0</subsheetid>
<narrative>This is an internally used class for opening the connection. It is not published for use in processes.</narrative>
<displayx>-195</displayx>
<displayy>-105</displayy>
<displaywidth>150</displaywidth>
<displayheight>90</displayheight>
</stage>
<stage stageid="f949525f-85f8-47a7-be5e-f000ba7d11b4" name="Start" type="Start">
<subsheetid>ea43971d-49fa-4f4e-9f46-9fc8bc6135b0</subsheetid>
<loginhibit />
<onsuccess>ff3c60b2-4193-4c8a-9df9-8676a2696d88</onsuccess>
<displayx>15</displayx>
<displayy>-105</displayy>
</stage>
<stage stageid="fd0e19e1-c17f-41e2-a4b7-16e8dd1846eb" name="End" type="End">
<subsheetid>ea43971d-49fa-4f4e-9f46-9fc8bc6135b0</subsheetid>
<loginhibit />
<outputs>
<output type="flag" name="IsOpen" stage="IsOpen" />
</outputs>
<displayx>15</displayx>
<displayy>15</displayy>
</stage>
<stage stageid="ff3c60b2-4193-4c8a-9df9-8676a2696d88" name="Check Connection" type="Code">
<subsheetid>ea43971d-49fa-4f4e-9f46-9fc8bc6135b0</subsheetid>
<loginhibit />
<outputs>
<output type="flag" name="IsOpen" stage="IsOpen" />
</outputs>
<onsuccess>fd0e19e1-c17f-41e2-a4b7-16e8dd1846eb</onsuccess>
<code><![CDATA[IsOpen = (moConnection != null &&
moConnection.State == ConnectionState.Open );]]></code>
<displayx>15</displayx>
<displayy>-45</displayy>
</stage>
<stage stageid="dc75f00e-e06f-44de-9d0c-cc30098de432" name="IsOpen" type="Data">
<subsheetid>ea43971d-49fa-4f4e-9f46-9fc8bc6135b0</subsheetid>
<datatype>flag</datatype>
<initialvalue />
<private />
<alwaysinit />
<displayx>-195</displayx>
<displayy>-30</displayy>
<displaywidth>90</displaywidth>
<displayheight>30</displayheight>
</stage>
<stage stageid="4065ce6e-1c47-4b70-8262-c2c5c5f5cb6f" name="Begin Transaction" type="SubSheetInfo">
<subsheetid>bad96847-65f0-40bc-be35-8d593764ca18</subsheetid>
<narrative>This stage allows a set of database interactions to be encapsulated in a transaction. This allows a set of interactions to be completed or aborted if conditions are not met. Begin Transaction is followed by a Commit Transaction or a Rollback Transaction.</narrative>
<displayx>-195</displayx>
<displayy>-105</displayy>
<displaywidth>150</displaywidth>
<displayheight>90</displayheight>
</stage>
<stage stageid="3ba69e93-639f-4512-8475-50a51c390097" name="Start" type="Start">
<subsheetid>bad96847-65f0-40bc-be35-8d593764ca18</subsheetid>
<loginhibit />
<onsuccess>305c4740-3ce8-42c9-87cb-c9177fcf7940</onsuccess>
<displayx>15</displayx>
<displayy>-225</displayy>
</stage>
<stage stageid="3689f512-b76e-4c1d-adb8-07d0367aabfe" name="End" type="End">
<subsheetid>bad96847-65f0-40bc-be35-8d593764ca18</subsheetid>
<loginhibit />
<outputs>
<output type="flag" name="Success" stage="Success" />
<output type="text" name="Message" stage="Message" />
</outputs>
<displayx>15</displayx>
<displayy>315</displayy>
</stage>
<stage stageid="a17df01e-59a9-47fa-8c7c-e0da07e4b881" name="Success" type="Data">
<subsheetid>bad96847-65f0-40bc-be35-8d593764ca18</subsheetid>
<loginhibit />
<datatype>flag</datatype>
<initialvalue>False</initialvalue>
<private />
<alwaysinit />
<displayx>-195</displayx>
<displayy>-15</displayy>
<displaywidth>90</displaywidth>
<displayheight>30</displayheight>
</stage>
<stage stageid="7ea7ac45-0d90-4ef2-95a3-d2b13ce82b9d" name="Message" type="Data">
<subsheetid>bad96847-65f0-40bc-be35-8d593764ca18</subsheetid>
<loginhibit />
<datatype>text</datatype>
<initialvalue />
<private />
<alwaysinit />
<displayx>-195</displayx>
<displayy>30</displayy>
<displaywidth>90</displaywidth>
<displayheight>30</displayheight>
</stage>
<stage stageid="f08172ca-ed7d-48d8-ae7d-e7bca732ec38" name="Is Open" type="Data">
<subsheetid>bad96847-65f0-40bc-be35-8d593764ca18</subsheetid>
<datatype>flag</datatype>
<initialvalue />
<private />
<alwaysinit />
<displayx>-195</displayx>
<displayy>105</displayy>
</stage>
<stage stageid="305c4740-3ce8-42c9-87cb-c9177fcf7940" name="In Transaction?" type="Decision">
<subsheetid>bad96847-65f0-40bc-be35-8d593764ca18</subsheetid>
<loginhibit />
<decision expression="[In Transaction]=True" />
<ontrue>a159b46d-3123-4ab7-b57a-a87e74ffc73d</ontrue>
<onfalse>1daa6365-d77c-4c76-93cc-0c6698c2cde9</onfalse>
<displayx>15</displayx>
<displayy>-165</displayy>
<displaywidth>90</displaywidth>
<displayheight>30</displayheight>
</stage>
<stage stageid="a159b46d-3123-4ab7-b57a-a87e74ffc73d" name="Transaction Already Open Error" type="Calculation">
<subsheetid>bad96847-65f0-40bc-be35-8d593764ca18</subsheetid>
<loginhibit />
<onsuccess>28a2d368-2750-4464-b15a-8d26593fdc2c</onsuccess>
<calculation expression="&quot;A transaction is already open in this connection&quot;" stage="Message" />
<displayx>240</displayx>
<displayy>-165</displayy>
<displaywidth>120</displaywidth>
<displayheight>30</displayheight>
</stage>
<stage stageid="1daa6365-d77c-4c76-93cc-0c6698c2cde9" name="Is Open" type="SubSheet">
<subsheetid>bad96847-65f0-40bc-be35-8d593764ca18</subsheetid>
<loginhibit />
<outputs>
<output type="flag" name="IsOpen" friendlyname="IsOpen" stage="Is Open" />
</outputs>
<onsuccess>9002fe90-08b3-46d5-b275-a43285a0f98c</onsuccess>
<processid>ea43971d-49fa-4f4e-9f46-9fc8bc6135b0</processid>
<displayx>15</displayx>
<displayy>-105</displayy>
</stage>
<stage stageid="9002fe90-08b3-46d5-b275-a43285a0f98c" name="Is Open?" type="Decision">
<subsheetid>bad96847-65f0-40bc-be35-8d593764ca18</subsheetid>
<loginhibit />
<decision expression="[Is Open]" />
<ontrue>b6946861-0c2f-4137-abc8-10fe43c66e24</ontrue>
<onfalse>58180489-d7c1-4201-bd7d-809850465982</onfalse>
<displayx>15</displayx>
<displayy>-45</displayy>
</stage>
<stage stageid="58180489-d7c1-4201-bd7d-809850465982" name="Open" type="SubSheet">
<subsheetid>bad96847-65f0-40bc-be35-8d593764ca18</subsheetid>
<loginhibit />
<outputs>
<output type="flag" name="Success" friendlyname="Success" stage="Success" />
<output type="text" name="Message" friendlyname="Message" stage="Message" />
</outputs>
<onsuccess>d2a69cd8-bcd7-4cd1-8c3f-4184ffbc973e</onsuccess>
<processid>d7f92fab-b3c7-4c06-ae2d-503e20b73fd7</processid>
<displayx>15</displayx>
<displayy>15</displayy>
</stage>
<stage stageid="96626c10-e852-42e3-a001-4549cb7f4623" name="Begin Transaction" type="Code">
<subsheetid>bad96847-65f0-40bc-be35-8d593764ca18</subsheetid>
<loginhibit />
<outputs>
<output type="flag" name="Success" stage="Success" />
<output type="text" name="Message" stage="Message" />
</outputs>
<onsuccess>f2f27764-a922-4a6d-92a7-f72eab3e84b4</onsuccess>
<code><![CDATA[// Assume Success
Success = true;
Message = "";
try
{
moTransaction = moConnection.BeginTransaction();
}
catch (Exception ex)
{
Success = false;
Message = ex.Message;
}]]></code>
<displayx>15</displayx>
<displayy>105</displayy>
</stage>
<stage stageid="d2a69cd8-bcd7-4cd1-8c3f-4184ffbc973e" name="Success?" type="Decision">
<subsheetid>bad96847-65f0-40bc-be35-8d593764ca18</subsheetid>
<loginhibit />
<decision expression="[Success]" />
<ontrue>65855cce-e52f-4d97-a96b-012e5349557c</ontrue>
<onfalse>28a2d368-2750-4464-b15a-8d26593fdc2c</onfalse>
<displayx>165</displayx>
<displayy>15</displayy>
</stage>
<stage stageid="b6946861-0c2f-4137-abc8-10fe43c66e24" name="Anchor10" type="Anchor">
<subsheetid>bad96847-65f0-40bc-be35-8d593764ca18</subsheetid>
<loginhibit />
<onsuccess>6cad040e-509d-46a8-8108-4be98c183541</onsuccess>
<displayx>-60</displayx>
<displayy>-45</displayy>
<displaywidth>10</displaywidth>
<displayheight>10</displayheight>
</stage>
<stage stageid="6cad040e-509d-46a8-8108-4be98c183541" name="Anchor11" type="Anchor">
<subsheetid>bad96847-65f0-40bc-be35-8d593764ca18</subsheetid>
<loginhibit />
<onsuccess>96626c10-e852-42e3-a001-4549cb7f4623</onsuccess>
<displayx>-60</displayx>
<displayy>105</displayy>
<displaywidth>10</displaywidth>
<displayheight>10</displayheight>
</stage>
<stage stageid="28a2d368-2750-4464-b15a-8d26593fdc2c" name="Anchor12" type="Anchor">
<subsheetid>bad96847-65f0-40bc-be35-8d593764ca18</subsheetid>
<loginhibit />
<onsuccess>ae19573b-2e87-4637-a274-25d168e78680</onsuccess>
<displayx>240</displayx>
<displayy>15</displayy>
<displaywidth>10</displaywidth>
<displayheight>10</displayheight>
</stage>
<stage stageid="65855cce-e52f-4d97-a96b-012e5349557c" name="Anchor13" type="Anchor">
<subsheetid>bad96847-65f0-40bc-be35-8d593764ca18</subsheetid>
<loginhibit />
<onsuccess>fec20de6-d538-4b3b-a925-a47cc306937f</onsuccess>
<displayx>165</displayx>
<displayy>60</displayy>
<displaywidth>10</displaywidth>
<displayheight>10</displayheight>
</stage>
<stage stageid="fec20de6-d538-4b3b-a925-a47cc306937f" name="Anchor14" type="Anchor">
<subsheetid>bad96847-65f0-40bc-be35-8d593764ca18</subsheetid>
<loginhibit />
<onsuccess>96626c10-e852-42e3-a001-4549cb7f4623</onsuccess>
<displayx>15</displayx>
<displayy>60</displayy>
<displaywidth>10</displaywidth>
<displayheight>10</displayheight>
</stage>
<stage stageid="f2f27764-a922-4a6d-92a7-f72eab3e84b4" name="Success?" type="Decision">
<subsheetid>bad96847-65f0-40bc-be35-8d593764ca18</subsheetid>
<loginhibit />
<decision expression="[Success]" />
<ontrue>cb024b07-868b-49ce-858f-9b8d0531a272</ontrue>
<onfalse>ae19573b-2e87-4637-a274-25d168e78680</onfalse>
<displayx>165</displayx>
<displayy>105</displayy>
</stage>
<stage stageid="cb024b07-868b-49ce-858f-9b8d0531a272" name="Anchor15" type="Anchor">
<subsheetid>bad96847-65f0-40bc-be35-8d593764ca18</subsheetid>
<loginhibit />
<onsuccess>b525bd2a-9970-40fa-b567-16834c27cbc0</onsuccess>
<displayx>165</displayx>
<displayy>150</displayy>
<displaywidth>10</displaywidth>
<displayheight>10</displayheight>
</stage>
<stage stageid="b525bd2a-9970-40fa-b567-16834c27cbc0" name="Anchor16" type="Anchor">
<subsheetid>bad96847-65f0-40bc-be35-8d593764ca18</subsheetid>
<loginhibit />
<onsuccess>f6038a48-f7cd-45a9-880c-b3834cfdfe80</onsuccess>
<displayx>15</displayx>
<displayy>150</displayy>
<displaywidth>10</displaywidth>
<displayheight>10</displayheight>
</stage>
<stage stageid="ae19573b-2e87-4637-a274-25d168e78680" name="Anchor17" type="Anchor">
<subsheetid>bad96847-65f0-40bc-be35-8d593764ca18</subsheetid>
<loginhibit />
<onsuccess>756ddf3a-99de-4ca6-bdbd-c3fee1a9df13</onsuccess>
<displayx>240</displayx>
<displayy>105</displayy>
<displaywidth>10</displaywidth>
<displayheight>10</displayheight>
</stage>
<stage stageid="756ddf3a-99de-4ca6-bdbd-c3fee1a9df13" name="Anchor18" type="Anchor">
<subsheetid>bad96847-65f0-40bc-be35-8d593764ca18</subsheetid>
<loginhibit />
<onsuccess>32cbf4a3-1b4d-4ca8-bc8e-683ca1157bb8</onsuccess>
<displayx>240</displayx>
<displayy>255</displayy>
<displaywidth>10</displaywidth>
<displayheight>10</displayheight>
</stage>
<stage stageid="f6038a48-f7cd-45a9-880c-b3834cfdfe80" name="In Transaction" type="Calculation">
<subsheetid>bad96847-65f0-40bc-be35-8d593764ca18</subsheetid>
<loginhibit />
<onsuccess>32cbf4a3-1b4d-4ca8-bc8e-683ca1157bb8</onsuccess>
<calculation expression="True" stage="In Transaction" />
<displayx>15</displayx>
<displayy>195</displayy>
</stage>
<stage stageid="32cbf4a3-1b4d-4ca8-bc8e-683ca1157bb8" name="Raise Exception If Appropriate" type="SubSheet">
<subsheetid>bad96847-65f0-40bc-be35-8d593764ca18</subsheetid>
<loginhibit />
<inputs>
<input type="flag" name="Success" friendlyname="Success" expr="[Success]" />
<input type="text" name="Error Message" friendlyname="Error Message" expr="[Message]" />
</inputs>
<onsuccess>3689f512-b76e-4c1d-adb8-07d0367aabfe</onsuccess>
<processid>88b62fd7-41a8-4bc7-806a-bd8e1b5497ca</processid>
<displayx>15</displayx>
<displayy>255</displayy>
</stage>
<stage stageid="895fa895-706a-4a87-b58c-fc7447df3ec9" name="Commit Transaction" type="SubSheetInfo">
<subsheetid>a487438c-3391-4a66-a1a6-5f40ebc64115</subsheetid>
<narrative>This stage compliments the Begin Transaction stage and makes all the changes made to the database since the transaction began permanent.</narrative>
<displayx>-195</displayx>
<displayy>-105</displayy>
<displaywidth>150</displaywidth>
<displayheight>60</displayheight>
</stage>
<stage stageid="36df4fbc-2057-442a-82b9-41d7de84fb92" name="Start" type="Start">
<subsheetid>a487438c-3391-4a66-a1a6-5f40ebc64115</subsheetid>
<loginhibit />
<onsuccess>94e929e2-3231-4b8f-b0ae-de11c09eb76d</onsuccess>
<displayx>15</displayx>
<displayy>-210</displayy>
</stage>
<stage stageid="c954c31b-e736-4bb0-b994-4b9ed1ec5ab4" name="End" type="End">
<subsheetid>a487438c-3391-4a66-a1a6-5f40ebc64115</subsheetid>
<loginhibit />
<outputs>
<output type="flag" name="Success" stage="Success" />
<output type="text" name="Message" stage="Message" />
</outputs>
<displayx>15</displayx>
<displayy>150</displayy>
</stage>
<stage stageid="96dfc38c-f94d-42e3-b8e3-a8cf4de91f33" name="Success" type="Data">
<subsheetid>a487438c-3391-4a66-a1a6-5f40ebc64115</subsheetid>
<datatype>flag</datatype>
<initialvalue />
<private />
<alwaysinit />
<displayx>-225</displayx>
<displayy>0</displayy>
</stage>
<stage stageid="9a8619c9-34f6-4134-b48b-0e621a307227" name="Message" type="Data">
<subsheetid>a487438c-3391-4a66-a1a6-5f40ebc64115</subsheetid>
<datatype>text</datatype>
<initialvalue />
<private />
<alwaysinit />
<displayx>-165</displayx>
<displayy>0</displayy>
</stage>
<stage stageid="6c060156-3f12-41f7-8d67-ed16b92ef73a" name="Close Success" type="Data">
<subsheetid>a487438c-3391-4a66-a1a6-5f40ebc64115</subsheetid>
<datatype>flag</datatype>
<initialvalue />
<private />
<alwaysinit />
<displayx>-225</displayx>
<displayy>75</displayy>
</stage>
<stage stageid="fb71a727-b8f2-439a-be45-42b4d566da1c" name="Close Message" type="Data">
<subsheetid>a487438c-3391-4a66-a1a6-5f40ebc64115</subsheetid>
<datatype>text</datatype>
<initialvalue />
<private />
<alwaysinit />
<displayx>-165</displayx>
<displayy>75</displayy>
</stage>
<stage stageid="94e929e2-3231-4b8f-b0ae-de11c09eb76d" name="In Transaction?" type="Decision">
<subsheetid>a487438c-3391-4a66-a1a6-5f40ebc64115</subsheetid>
<loginhibit />
<decision expression="[In Transaction]" />
<ontrue>1024802e-1bc7-413e-a614-5fb979be08e9</ontrue>
<onfalse>a49ce9aa-12b2-4283-af07-713e9267f698</onfalse>
<displayx>15</displayx>
<displayy>-150</displayy>
<displaywidth>90</displaywidth>
<displayheight>30</displayheight>
</stage>
<stage stageid="1024802e-1bc7-413e-a614-5fb979be08e9" name="Commit Transaction" type="Code">
<subsheetid>a487438c-3391-4a66-a1a6-5f40ebc64115</subsheetid>
<loginhibit />
<outputs>
<output type="flag" name="Success" stage="Success" />
<output type="text" name="Message" stage="Message" />
</outputs>
<onsuccess>fac1dbed-718a-4386-9328-dc305b7ac7d5</onsuccess>
<code><![CDATA[
// Assume success
Success = true;
Message = "";
try
{
moTransaction.Commit();
moTransaction = null;
}
catch (Exception ex)
{
Success = false;
Message = ex.Message;
}
]]></code>
<displayx>15</displayx>
<displayy>-90</displayy>
</stage>
<stage stageid="fac1dbed-718a-4386-9328-dc305b7ac7d5" name="Not In Transaction" type="Calculation">
<subsheetid>a487438c-3391-4a66-a1a6-5f40ebc64115</subsheetid>
<loginhibit />
<onsuccess>6dd9fd73-0fdb-4728-9802-e4dccf3cfef8</onsuccess>
<calculation expression="False" stage="In Transaction" />
<displayx>15</displayx>
<displayy>-30</displayy>
</stage>
<stage stageid="6dd9fd73-0fdb-4728-9802-e4dccf3cfef8" name="Internal Close" type="SubSheet">
<subsheetid>a487438c-3391-4a66-a1a6-5f40ebc64115</subsheetid>
<loginhibit />
<inputs>
<input type="flag" name="Clear Pool" friendlyname="Clear Pool" expr="False" />
</inputs>
<outputs>
<output type="flag" name="Success" friendlyname="Success" stage="Close Success" />
<output type="text" name="Message" friendlyname="Message" stage="Close Message" />
</outputs>
<onsuccess>590371f6-974e-4815-86a8-67942e585fa8</onsuccess>
<processid>f64b457a-dfb7-4200-9a9f-5dd147561478</processid>
<displayx>15</displayx>
<displayy>30</displayy>
</stage>
<stage stageid="590371f6-974e-4815-86a8-67942e585fa8" name="Raise Exception If Appropriate" type="SubSheet">
<subsheetid>a487438c-3391-4a66-a1a6-5f40ebc64115</subsheetid>
<loginhibit />
<inputs>
<input type="flag" name="Success" friendlyname="Success" expr="[Success]" />
<input type="text" name="Error Message" friendlyname="Error Message" expr="[Message]" />
</inputs>
<onsuccess>c954c31b-e736-4bb0-b994-4b9ed1ec5ab4</onsuccess>
<processid>88b62fd7-41a8-4bc7-806a-bd8e1b5497ca</processid>
<displayx>15</displayx>
<displayy>90</displayy>
</stage>
<stage stageid="a49ce9aa-12b2-4283-af07-713e9267f698" name="Error Message" type="Calculation">
<subsheetid>a487438c-3391-4a66-a1a6-5f40ebc64115</subsheetid>
<loginhibit />
<onsuccess>8e59ca16-e536-4c5e-9241-fd0c51914997</onsuccess>
<calculation expression="&quot;There is no open transaction to commit&quot;" stage="Message" />
<displayx>135</displayx>
<displayy>-150</displayy>
</stage>
<stage stageid="8e59ca16-e536-4c5e-9241-fd0c51914997" name="Anchor19" type="Anchor">
<subsheetid>a487438c-3391-4a66-a1a6-5f40ebc64115</subsheetid>
<loginhibit />
<onsuccess>6dd9fd73-0fdb-4728-9802-e4dccf3cfef8</onsuccess>
<displayx>135</displayx>
<displayy>30</displayy>
<displaywidth>10</displaywidth>
<displayheight>10</displayheight>
</stage>
<stage stageid="433baee6-4ddb-444c-923e-401a184aaf56" name="Execute" type="SubSheetInfo">
<subsheetid>540e741c-c8b3-4b39-9574-4abc24bd8bc9</subsheetid>
<narrative>This stage takes an SQL command and passes it to the database. Data items capture the success of the execution.</narrative>
<displayx>-195</displayx>
<displayy>-105</displayy>
<displaywidth>150</displaywidth>
<displayheight>60</displayheight>
</stage>
<stage stageid="2c2322b6-e86f-41e8-b426-b9175d1e01e9" name="Start" type="Start">
<subsheetid>540e741c-c8b3-4b39-9574-4abc24bd8bc9</subsheetid>
<loginhibit />
<inputs>
<input type="text" name="Query" stage="SQL" />
</inputs>
<onsuccess>0813c4d4-7de4-4684-a88e-57f6ca904fce</onsuccess>
<displayx>15</displayx>
<displayy>-90</displayy>
</stage>
<stage stageid="d2d388d8-b1b2-48b1-9a3a-819c33e65bfb" name="End" type="End">
<subsheetid>540e741c-c8b3-4b39-9574-4abc24bd8bc9</subsheetid>
<loginhibit />
<outputs>
<output type="flag" name="Success" stage="Success" />
<output type="text" name="Message" stage="Message" />
<output type="number" name="RecordsAffected" stage="Records Affected" />
</outputs>
<displayx>15</displayx>
<displayy>150</displayy>
</stage>
<stage stageid="1748f04c-c981-4b1a-925b-eaa15b02b4f5" name="Success" type="Data">
<subsheetid>540e741c-c8b3-4b39-9574-4abc24bd8bc9</subsheetid>
<loginhibit />
<datatype>flag</datatype>
<initialvalue>False</initialvalue>
<private />
<alwaysinit />
<displayx>-195</displayx>
<displayy>45</displayy>
<displaywidth>120</displaywidth>
<displayheight>30</displayheight>
</stage>
<stage stageid="51fa435a-b24a-4046-9542-1449008b1c2c" name="Message" type="Data">
<subsheetid>540e741c-c8b3-4b39-9574-4abc24bd8bc9</subsheetid>
<loginhibit />
<datatype>text</datatype>
<initialvalue />
<private />
<alwaysinit />
<displayx>-195</displayx>
<displayy>90</displayy>
<displaywidth>120</displaywidth>
<displayheight>30</displayheight>
</stage>
<stage stageid="8bfc7f6b-ef8c-4283-87e3-69bba1350544" name="SQL" type="Data">
<subsheetid>540e741c-c8b3-4b39-9574-4abc24bd8bc9</subsheetid>
<loginhibit />
<datatype>text</datatype>
<initialvalue />
<private />
<alwaysinit />
<displayx>-195</displayx>
<displayy>-30</displayy>
</stage>
<stage stageid="a9ac5ccc-09c9-4d98-942d-646ddddbf871" name="Close Success" type="Data">
<subsheetid>540e741c-c8b3-4b39-9574-4abc24bd8bc9</subsheetid>
<datatype>flag</datatype>
<initialvalue />
<private />
<alwaysinit />
<displayx>-225</displayx>
<displayy>165</displayy>
<displaywidth>90</displaywidth>
<displayheight>30</displayheight>
</stage>
<stage stageid="ff6c1465-2222-4720-b895-5279dc5a93cf" name="Close Message" type="Data">
<subsheetid>540e741c-c8b3-4b39-9574-4abc24bd8bc9</subsheetid>
<datatype>text</datatype>
<initialvalue />
<private />
<alwaysinit />
<displayx>-150</displayx>
<displayy>165</displayy>
<displaywidth>90</displaywidth>
<displayheight>30</displayheight>
</stage>
<stage stageid="0813c4d4-7de4-4684-a88e-57f6ca904fce" name="Execute" type="Code">
<subsheetid>540e741c-c8b3-4b39-9574-4abc24bd8bc9</subsheetid>
<loginhibit />
<inputs>
<input type="text" name="SQL" expr="[SQL]" />
</inputs>
<outputs>
<output type="flag" name="Success" stage="Success" />
<output type="text" name="Message" stage="Message" />
<output type="number" name="RecordsAffected" stage="Records Affected" />
</outputs>
<onsuccess>1ee380a9-7288-42c3-a7f7-5b7b867e7ddd</onsuccess>
<code><![CDATA[
Success = true;
Message = "";
RecordsAffected = 0;
try
{
using (OracleCommand cmd = new OracleCommand())
{
cmd.Connection = moConnection;
cmd.CommandText = SQL;
cmd.Transaction = moTransaction;
RecordsAffected = cmd.ExecuteNonQuery();
}
}
catch (Exception ex)
{
Success = false;
Message = ex.Message;
}
]]></code>
<displayx>15</displayx>
<displayy>-30</displayy>
</stage>
<stage stageid="1ee380a9-7288-42c3-a7f7-5b7b867e7ddd" name="In Transaction?" type="Decision">
<subsheetid>540e741c-c8b3-4b39-9574-4abc24bd8bc9</subsheetid>
<loginhibit />
<decision expression="[In Transaction]=True" />
<ontrue>a232f17d-eb06-431c-9038-6737f8dc27b1</ontrue>
<onfalse>a2317feb-7a3f-43cd-9630-f658abf0132c</onfalse>
<displayx>15</displayx>
<displayy>30</displayy>
</stage>
<stage stageid="a232f17d-eb06-431c-9038-6737f8dc27b1" name="Raise Exception If Appropriate" type="SubSheet">
<subsheetid>540e741c-c8b3-4b39-9574-4abc24bd8bc9</subsheetid>
<loginhibit />
<inputs>
<input type="flag" name="Success" friendlyname="Success" expr="[Success]" />
<input type="text" name="Error Message" friendlyname="Error Message" expr="[Message]" />
</inputs>
<onsuccess>d2d388d8-b1b2-48b1-9a3a-819c33e65bfb</onsuccess>
<processid>88b62fd7-41a8-4bc7-806a-bd8e1b5497ca</processid>
<displayx>15</displayx>
<displayy>90</displayy>
</stage>
<stage stageid="a2317feb-7a3f-43cd-9630-f658abf0132c" name="Internal Close" type="SubSheet">
<subsheetid>540e741c-c8b3-4b39-9574-4abc24bd8bc9</subsheetid>
<loginhibit />
<inputs>
<input type="flag" name="Clear Pool" friendlyname="Clear Pool" expr="False" />
</inputs>
<outputs>
<output type="flag" name="Success" friendlyname="Success" stage="Close Success" />
<output type="text" name="Message" friendlyname="Message" stage="Close Message" />
</outputs>
<onsuccess>c23f3cee-9332-483c-9958-a778ed907c44</onsuccess>
<processid>f64b457a-dfb7-4200-9a9f-5dd147561478</processid>
<displayx>105</displayx>
<displayy>30</displayy>
</stage>
<stage stageid="c23f3cee-9332-483c-9958-a778ed907c44" name="Anchor21" type="Anchor">
<subsheetid>540e741c-c8b3-4b39-9574-4abc24bd8bc9</subsheetid>
<loginhibit />
<onsuccess>2d996066-041b-479f-90f8-ec92b75f48de</onsuccess>
<displayx>165</displayx>
<displayy>30</displayy>
<displaywidth>10</displaywidth>
<displayheight>10</displayheight>
</stage>
<stage stageid="2d996066-041b-479f-90f8-ec92b75f48de" name="Anchor22" type="Anchor">
<subsheetid>540e741c-c8b3-4b39-9574-4abc24bd8bc9</subsheetid>
<loginhibit />
<onsuccess>a232f17d-eb06-431c-9038-6737f8dc27b1</onsuccess>
<displayx>165</displayx>
<displayy>90</displayy>
<displaywidth>10</displaywidth>
<displayheight>10</displayheight>
</stage>
<stage stageid="a791e73f-5ec3-4513-b532-9e48c2166559" name="Get Number" type="SubSheetInfo">
<subsheetid>032119f9-342d-4b7e-ab12-c018b781a2f3</subsheetid>
<narrative>This function executes an SQL script and returns a single numeric value. </narrative>
<displayx>-195</displayx>
<displayy>-105</displayy>
<displaywidth>150</displaywidth>
<displayheight>90</displayheight>
</stage>
<stage stageid="3251453a-d3be-44fc-a8c8-762a8514431e" name="Start" type="Start">
<subsheetid>032119f9-342d-4b7e-ab12-c018b781a2f3</subsheetid>
<loginhibit />
<inputs>
<input type="text" name="Query" stage="SQL" />
</inputs>
<onsuccess>48fa6d08-a0dc-4c5f-8429-6b3cbd113488</onsuccess>
<displayx>15</displayx>
<displayy>-135</displayy>
</stage>
<stage stageid="89f57094-f59a-43aa-987f-446f205a5077" name="End" type="End">
<subsheetid>032119f9-342d-4b7e-ab12-c018b781a2f3</subsheetid>
<loginhibit />
<outputs>
<output type="number" name="Result" stage="Number Result" />
<output type="flag" name="Success" stage="Success" />
<output type="text" name="Message" stage="Message" />
</outputs>
<displayx>15</displayx>
<displayy>225</displayy>
</stage>
<stage stageid="48fa6d08-a0dc-4c5f-8429-6b3cbd113488" name="Open" type="SubSheet">
<subsheetid>032119f9-342d-4b7e-ab12-c018b781a2f3</subsheetid>
<loginhibit />
<outputs>
<output type="flag" name="Success" friendlyname="Success" stage="Success" />
<output type="text" name="Message" friendlyname="Message" stage="Message" />
</outputs>
<onsuccess>80a533b4-febb-4c46-ba06-917a4b6357f7</onsuccess>
<processid>d7f92fab-b3c7-4c06-ae2d-503e20b73fd7</processid>
<displayx>15</displayx>
<displayy>-75</displayy>
</stage>
<stage stageid="549b5f6a-6c30-40e6-8479-8050e0a0931e" name="Number Result" type="Data">
<subsheetid>032119f9-342d-4b7e-ab12-c018b781a2f3</subsheetid>
<loginhibit />
<datatype>number</datatype>
<initialvalue>0</initialvalue>
<private />
<displayx>-195</displayx>
<displayy>150</displayy>
<displaywidth>120</displaywidth>
<displayheight>30</displayheight>
</stage>
<stage stageid="c94807fa-4d78-4003-aa6b-f8d4736ef68a" name="Success" type="Data">
<subsheetid>032119f9-342d-4b7e-ab12-c018b781a2f3</subsheetid>
<loginhibit />
<datatype>flag</datatype>
<initialvalue>False</initialvalue>
<private />
<alwaysinit />
<displayx>-195</displayx>
<displayy>60</displayy>
<displaywidth>120</displaywidth>
<displayheight>30</displayheight>
</stage>
<stage stageid="ba6b562b-84ff-42d0-ba7b-7683788693f7" name="Message" type="Data">
<subsheetid>032119f9-342d-4b7e-ab12-c018b781a2f3</subsheetid>
<loginhibit />
<datatype>text</datatype>
<initialvalue />
<private />
<alwaysinit />
<displayx>-195</displayx>
<displayy>105</displayy>
<displaywidth>120</displaywidth>
<displayheight>30</displayheight>
</stage>
<stage stageid="7e0767a4-d8f8-46d0-8064-ceb9b2dfdade" name="Close Success" type="Data">
<subsheetid>032119f9-342d-4b7e-ab12-c018b781a2f3</subsheetid>
<datatype>flag</datatype>
<initialvalue />
<private />
<alwaysinit />
<displayx>-195</displayx>
<displayy>225</displayy>
<displaywidth>120</displaywidth>
<displayheight>30</displayheight>
</stage>
<stage stageid="396a3354-1b33-4ce9-aee8-ff044eb9f446" name="Close Message" type="Data">
<subsheetid>032119f9-342d-4b7e-ab12-c018b781a2f3</subsheetid>
<datatype>text</datatype>
<initialvalue />
<private />
<alwaysinit />
<displayx>-195</displayx>
<displayy>270</displayy>
<displaywidth>120</displaywidth>
<displayheight>30</displayheight>
</stage>
<stage stageid="396d16f0-2400-4844-9503-7becf3b506a2" name="SQL" type="Data">
<subsheetid>032119f9-342d-4b7e-ab12-c018b781a2f3</subsheetid>
<loginhibit />
<datatype>text</datatype>
<initialvalue />
<private />
<alwaysinit />
<displayx>-195</displayx>
<displayy>-15</displayy>
<displaywidth>120</displaywidth>
<displayheight>30</displayheight>
</stage>
<stage stageid="80a533b4-febb-4c46-ba06-917a4b6357f7" name="Success?" type="Decision">
<subsheetid>032119f9-342d-4b7e-ab12-c018b781a2f3</subsheetid>
<loginhibit />
<decision expression="[Success]" />
<ontrue>39b89cf7-5815-4375-92b6-41642be882bf</ontrue>
<onfalse>56dba29f-03e1-4022-ad8a-2ec6f22e7756</onfalse>
<displayx>15</displayx>
<displayy>-15</displayy>
</stage>
<stage stageid="39b89cf7-5815-4375-92b6-41642be882bf" name="Execute Return Number" type="Code">
<subsheetid>032119f9-342d-4b7e-ab12-c018b781a2f3</subsheetid>
<loginhibit />
<inputs>
<input type="text" name="SQL" expr="[SQL]" />
</inputs>
<outputs>
<output type="flag" name="Success" stage="Success" />
<output type="text" name="Message" stage="Message" />
<output type="number" name="Result" stage="Number Result" />
</outputs>
<onsuccess>980361a8-5100-43e6-9a2e-769382e5f8ca</onsuccess>
<code><![CDATA[Message = "";
Success = false;
Result = GetScalar<Decimal>( SQL, Success, Message);]]></code>
<displayx>15</displayx>
<displayy>45</displayy>
</stage>
<stage stageid="980361a8-5100-43e6-9a2e-769382e5f8ca" name="In Transaction?" type="Decision">
<subsheetid>032119f9-342d-4b7e-ab12-c018b781a2f3</subsheetid>
<loginhibit />
<decision expression="[In Transaction]" />
<ontrue>5940f7d2-8ffc-475d-8b0f-5c2c6d53feea</ontrue>
<onfalse>c31a4854-aecd-4985-a9e7-aea16c8003b7</onfalse>
<displayx>15</displayx>
<displayy>105</displayy>
</stage>
<stage stageid="5940f7d2-8ffc-475d-8b0f-5c2c6d53feea" name="Raise Exception If Appropriate" type="SubSheet">
<subsheetid>032119f9-342d-4b7e-ab12-c018b781a2f3</subsheetid>
<loginhibit />
<inputs>
<input type="flag" name="Success" friendlyname="Success" expr="[Success]" />
<input type="text" name="Error Message" friendlyname="Error Message" expr="[Message]" />
</inputs>
<onsuccess>89f57094-f59a-43aa-987f-446f205a5077</onsuccess>
<processid>88b62fd7-41a8-4bc7-806a-bd8e1b5497ca</processid>
<displayx>15</displayx>
<displayy>165</displayy>
</stage>
<stage stageid="c31a4854-aecd-4985-a9e7-aea16c8003b7" name="Internal Close" type="SubSheet">
<subsheetid>032119f9-342d-4b7e-ab12-c018b781a2f3</subsheetid>
<loginhibit />
<inputs>
<input type="flag" name="Clear Pool" friendlyname="Clear Pool" expr="False" />
</inputs>
<outputs>
<output type="flag" name="Success" friendlyname="Success" stage="Close Success" />
<output type="text" name="Message" friendlyname="Message" stage="Close Message" />
</outputs>
<onsuccess>26500a11-bbce-44c3-8e45-68ca85d69d54</onsuccess>
<processid>f64b457a-dfb7-4200-9a9f-5dd147561478</processid>
<displayx>105</displayx>
<displayy>105</displayy>
</stage>
<stage stageid="56dba29f-03e1-4022-ad8a-2ec6f22e7756" name="Anchor23" type="Anchor">
<subsheetid>032119f9-342d-4b7e-ab12-c018b781a2f3</subsheetid>
<loginhibit />
<onsuccess>26500a11-bbce-44c3-8e45-68ca85d69d54</onsuccess>
<displayx>165</displayx>
<displayy>-15</displayy>
<displaywidth>10</displaywidth>
<displayheight>10</displayheight>
</stage>
<stage stageid="26500a11-bbce-44c3-8e45-68ca85d69d54" name="Anchor24" type="Anchor">
<subsheetid>032119f9-342d-4b7e-ab12-c018b781a2f3</subsheetid>
<loginhibit />
<onsuccess>a6706a91-6a56-4275-a7b1-03dd1cb25589</onsuccess>
<displayx>165</displayx>
<displayy>105</displayy>
<displaywidth>10</displaywidth>
<displayheight>10</displayheight>
</stage>
<stage stageid="a6706a91-6a56-4275-a7b1-03dd1cb25589" name="Anchor25" type="Anchor">
<subsheetid>032119f9-342d-4b7e-ab12-c018b781a2f3</subsheetid>
<loginhibit />
<onsuccess>5940f7d2-8ffc-475d-8b0f-5c2c6d53feea</onsuccess>
<displayx>165</displayx>
<displayy>165</displayy>
<displaywidth>10</displaywidth>
<displayheight>10</displayheight>
</stage>
<stage stageid="5b0ebf82-3a83-4927-bcc4-7cf58dd01890" name="Get Text" type="SubSheetInfo">
<subsheetid>48d79c6a-7dc2-4a23-a601-7421f7fb5280</subsheetid>
<narrative>This function executes an SQL script and returns a text result.</narrative>
<displayx>-195</displayx>
<displayy>-105</displayy>
<displaywidth>150</displaywidth>
<displayheight>90</displayheight>
</stage>
<stage stageid="34072de5-4529-4f60-9f2a-209932886d3c" name="Start" type="Start">
<subsheetid>48d79c6a-7dc2-4a23-a601-7421f7fb5280</subsheetid>
<loginhibit />
<inputs>
<input type="text" name="Query" stage="SQL" />
</inputs>
<onsuccess>fc305383-c47a-4f28-a7d7-ad80b28d2b13</onsuccess>
<displayx>15</displayx>
<displayy>-135</displayy>
</stage>
<stage stageid="d42242fc-d402-4c94-8156-6ca9096507e1" name="End" type="End">
<subsheetid>48d79c6a-7dc2-4a23-a601-7421f7fb5280</subsheetid>
<loginhibit />
<outputs>
<output type="text" name="Result" stage="Text Result" />
<output type="flag" name="Success" stage="Success" />
<output type="text" name="Message" stage="Message" />
</outputs>
<displayx>15</displayx>
<displayy>225</displayy>
</stage>
<stage stageid="fc305383-c47a-4f28-a7d7-ad80b28d2b13" name="Open" type="SubSheet">
<subsheetid>48d79c6a-7dc2-4a23-a601-7421f7fb5280</subsheetid>
<loginhibit />
<outputs>
<output type="flag" name="Success" friendlyname="Success" stage="Success" />
<output type="text" name="Message" friendlyname="Message" stage="Message" />
</outputs>
<onsuccess>2266b86c-83df-475b-9aa3-f4f63809de2d</onsuccess>
<processid>d7f92fab-b3c7-4c06-ae2d-503e20b73fd7</processid>
<displayx>15</displayx>
<displayy>-75</displayy>
</stage>
<stage stageid="318e4f05-823a-4005-a07b-16b7cfd13ab4" name="Text Result" type="Data">
<subsheetid>48d79c6a-7dc2-4a23-a601-7421f7fb5280</subsheetid>
<loginhibit />
<datatype>text</datatype>
<initialvalue />
<private />
<displayx>-195</displayx>
<displayy>150</displayy>
<displaywidth>120</displaywidth>
<displayheight>30</displayheight>
</stage>
<stage stageid="2bcd6ed9-3fd1-453e-ae65-48c91222db45" name="Success" type="Data">
<subsheetid>48d79c6a-7dc2-4a23-a601-7421f7fb5280</subsheetid>
<loginhibit />
<datatype>flag</datatype>
<initialvalue>False</initialvalue>
<private />
<alwaysinit />
<displayx>-195</displayx>
<displayy>60</displayy>
<displaywidth>120</displaywidth>
<displayheight>30</displayheight>
</stage>
<stage stageid="d1b8bb35-bf43-4c74-b41b-8735f4c4c7f5" name="Message" type="Data">
<subsheetid>48d79c6a-7dc2-4a23-a601-7421f7fb5280</subsheetid>
<loginhibit />
<datatype>text</datatype>
<initialvalue />
<private />
<alwaysinit />
<displayx>-195</displayx>
<displayy>105</displayy>
<displaywidth>120</displaywidth>
<displayheight>30</displayheight>
</stage>
<stage stageid="3197cef8-a9bd-4eef-8b93-8c3d265f6b50" name="Close Success" type="Data">
<subsheetid>48d79c6a-7dc2-4a23-a601-7421f7fb5280</subsheetid>
<datatype>flag</datatype>
<initialvalue />
<private />
<alwaysinit />
<displayx>-195</displayx>
<displayy>225</displayy>
<displaywidth>120</displaywidth>
<displayheight>30</displayheight>
</stage>
<stage stageid="fd8d71a7-c610-484e-a9a9-c66b4c7b7cab" name="Close Message" type="Data">
<subsheetid>48d79c6a-7dc2-4a23-a601-7421f7fb5280</subsheetid>
<datatype>text</datatype>
<initialvalue />
<private />
<alwaysinit />
<displayx>-195</displayx>
<displayy>270</displayy>
<displaywidth>120</displaywidth>
<displayheight>30</displayheight>
</stage>
<stage stageid="545dc8a1-718a-445f-bac0-55724ef452cd" name="SQL" type="Data">
<subsheetid>48d79c6a-7dc2-4a23-a601-7421f7fb5280</subsheetid>
<loginhibit />
<datatype>text</datatype>
<initialvalue />
<private />
<alwaysinit />
<displayx>-195</displayx>
<displayy>-15</displayy>
<displaywidth>120</displaywidth>
<displayheight>30</displayheight>
</stage>
<stage stageid="2266b86c-83df-475b-9aa3-f4f63809de2d" name="Success?" type="Decision">
<subsheetid>48d79c6a-7dc2-4a23-a601-7421f7fb5280</subsheetid>
<loginhibit />
<decision expression="[Success]" />
<ontrue>0f9a8e20-7efd-4d78-8ef9-6befbaf29b01</ontrue>
<onfalse>f912cd86-1564-408d-8a47-cd02b3fe7e1f</onfalse>
<displayx>15</displayx>
<displayy>-15</displayy>
</stage>
<stage stageid="0f9a8e20-7efd-4d78-8ef9-6befbaf29b01" name="Execute Return Text" type="Code">
<subsheetid>48d79c6a-7dc2-4a23-a601-7421f7fb5280</subsheetid>
<loginhibit />
<inputs>
<input type="text" name="SQL" expr="[SQL]" />
</inputs>
<outputs>
<output type="flag" name="Success" stage="Success" />
<output type="text" name="Message" stage="Message" />
<output type="text" name="Result" stage="Text Result" />
</outputs>
<onsuccess>a36204ca-bbc5-49a9-a110-cce06b0b6301</onsuccess>
<code><![CDATA[Message = "";
Success = false;
Result = GetScalar<string>( SQL, Success, Message);]]></code>
<displayx>15</displayx>
<displayy>45</displayy>
</stage>
<stage stageid="a36204ca-bbc5-49a9-a110-cce06b0b6301" name="In Transaction?" type="Decision">
<subsheetid>48d79c6a-7dc2-4a23-a601-7421f7fb5280</subsheetid>
<loginhibit />
<decision expression="[In Transaction]" />
<ontrue>364d6551-8415-4474-be5b-df96c30edef3</ontrue>
<onfalse>780dcffe-6d6d-45cc-a023-9a0836f639aa</onfalse>
<displayx>15</displayx>
<displayy>105</displayy>
</stage>
<stage stageid="364d6551-8415-4474-be5b-df96c30edef3" name="Raise Exception If Appropriate" type="SubSheet">
<subsheetid>48d79c6a-7dc2-4a23-a601-7421f7fb5280</subsheetid>
<loginhibit />
<inputs>
<input type="flag" name="Success" friendlyname="Success" expr="[Success]" />
<input type="text" name="Error Message" friendlyname="Error Message" expr="[Message]" />
</inputs>
<onsuccess>d42242fc-d402-4c94-8156-6ca9096507e1</onsuccess>
<processid>88b62fd7-41a8-4bc7-806a-bd8e1b5497ca</processid>
<displayx>15</displayx>
<displayy>165</displayy>
</stage>
<stage stageid="780dcffe-6d6d-45cc-a023-9a0836f639aa" name="Internal Close" type="SubSheet">
<subsheetid>48d79c6a-7dc2-4a23-a601-7421f7fb5280</subsheetid>
<loginhibit />
<inputs>
<input type="flag" name="Clear Pool" friendlyname="Clear Pool" expr="False" />
</inputs>
<outputs>
<output type="flag" name="Success" friendlyname="Success" stage="Close Success" />
<output type="text" name="Message" friendlyname="Message" stage="Close Message" />
</outputs>
<onsuccess>b0d0782a-9018-49b6-bb6d-2c458e02a802</onsuccess>
<processid>f64b457a-dfb7-4200-9a9f-5dd147561478</processid>
<displayx>105</displayx>
<displayy>105</displayy>
</stage>
<stage stageid="f912cd86-1564-408d-8a47-cd02b3fe7e1f" name="Anchor23" type="Anchor">
<subsheetid>48d79c6a-7dc2-4a23-a601-7421f7fb5280</subsheetid>
<loginhibit />
<onsuccess>b0d0782a-9018-49b6-bb6d-2c458e02a802</onsuccess>
<displayx>165</displayx>
<displayy>-15</displayy>
<displaywidth>10</displaywidth>
<displayheight>10</displayheight>
</stage>
<stage stageid="b0d0782a-9018-49b6-bb6d-2c458e02a802" name="Anchor24" type="Anchor">
<subsheetid>48d79c6a-7dc2-4a23-a601-7421f7fb5280</subsheetid>
<loginhibit />
<onsuccess>9a0b5862-76d6-42c6-95a2-875461b74ec8</onsuccess>
<displayx>165</displayx>
<displayy>105</displayy>
<displaywidth>10</displaywidth>
<displayheight>10</displayheight>
</stage>
<stage stageid="9a0b5862-76d6-42c6-95a2-875461b74ec8" name="Anchor25" type="Anchor">
<subsheetid>48d79c6a-7dc2-4a23-a601-7421f7fb5280</subsheetid>
<loginhibit />
<onsuccess>364d6551-8415-4474-be5b-df96c30edef3</onsuccess>
<displayx>165</displayx>
<displayy>165</displayy>
<displaywidth>10</displaywidth>
<displayheight>10</displayheight>
</stage>
<stage stageid="0e2faa3d-cec9-43ac-8d00-40a71bc1c31b" name="Get Collection" type="SubSheetInfo">
<subsheetid>a05c17eb-69e9-4f1e-b50c-cc1c353eef22</subsheetid>
<narrative>This function executes a SQL Select statement and returns the resulting records in a Blue Prism collection data item. </narrative>
<displayx>-195</displayx>
<displayy>-105</displayy>
<displaywidth>150</displaywidth>
<displayheight>60</displayheight>
</stage>
<stage stageid="a20130b0-b98e-48a2-b913-3b8eb5e50b20" name="Start" type="Start">
<subsheetid>a05c17eb-69e9-4f1e-b50c-cc1c353eef22</subsheetid>
<loginhibit />
<inputs>
<input type="text" name="SelectQuery" stage="SQL" />
</inputs>
<onsuccess>40c0811e-c5c9-4433-b02f-cc795a22f26a</onsuccess>
<displayx>15</displayx>
<displayy>-135</displayy>
</stage>
<stage stageid="4f5ac921-1a02-42f0-880d-2206482112c8" name="End" type="End">
<subsheetid>a05c17eb-69e9-4f1e-b50c-cc1c353eef22</subsheetid>
<loginhibit />
<outputs>
<output type="collection" name="Result" stage="Results" />
<output type="flag" name="Success" stage="Success" />
<output type="text" name="Message" stage="Message" />
</outputs>
<displayx>15</displayx>
<displayy>225</displayy>
</stage>
<stage stageid="40c0811e-c5c9-4433-b02f-cc795a22f26a" name="Open" type="SubSheet">
<subsheetid>a05c17eb-69e9-4f1e-b50c-cc1c353eef22</subsheetid>
<loginhibit />
<outputs>
<output type="flag" name="Success" friendlyname="Success" stage="Success" />
<output type="text" name="Message" friendlyname="Message" stage="Message" />
</outputs>
<onsuccess>3596eb65-1f27-439f-aad3-3da420a8078d</onsuccess>
<processid>d7f92fab-b3c7-4c06-ae2d-503e20b73fd7</processid>
<displayx>15</displayx>
<displayy>-75</displayy>
</stage>
<stage stageid="5812541e-8b0f-4467-8958-9e4e4edcf4e6" name="Success" type="Data">
<subsheetid>a05c17eb-69e9-4f1e-b50c-cc1c353eef22</subsheetid>
<loginhibit />
<datatype>flag</datatype>
<initialvalue>False</initialvalue>
<private />
<alwaysinit />
<displayx>-195</displayx>
<displayy>60</displayy>
<displaywidth>120</displaywidth>
<displayheight>30</displayheight>
</stage>
<stage stageid="8dd701ee-bc0d-4f04-84a0-ebd90793ec9b" name="Message" type="Data">
<subsheetid>a05c17eb-69e9-4f1e-b50c-cc1c353eef22</subsheetid>
<loginhibit />
<datatype>text</datatype>
<initialvalue />
<private />
<alwaysinit />
<displayx>-195</displayx>
<displayy>105</displayy>
<displaywidth>120</displaywidth>
<displayheight>30</displayheight>
</stage>
<stage stageid="5865fd04-bfe2-4c3f-afdd-86e87419763b" name="Close Success" type="Data">
<subsheetid>a05c17eb-69e9-4f1e-b50c-cc1c353eef22</subsheetid>
<datatype>flag</datatype>
<initialvalue />
<private />
<alwaysinit />
<displayx>-195</displayx>
<displayy>225</displayy>
<displaywidth>120</displaywidth>
<displayheight>30</displayheight>
</stage>
<stage stageid="53df7ef0-edab-4b61-b81c-964e49079168" name="Close Message" type="Data">
<subsheetid>a05c17eb-69e9-4f1e-b50c-cc1c353eef22</subsheetid>
<datatype>text</datatype>
<initialvalue />
<private />
<alwaysinit />
<displayx>-195</displayx>
<displayy>270</displayy>
<displaywidth>120</displaywidth>
<displayheight>30</displayheight>
</stage>
<stage stageid="1615faac-6ec9-4ff5-85c8-fcb44c172a50" name="SQL" type="Data">
<subsheetid>a05c17eb-69e9-4f1e-b50c-cc1c353eef22</subsheetid>
<loginhibit />
<datatype>text</datatype>
<initialvalue />
<private />
<alwaysinit />
<displayx>-195</displayx>
<displayy>-15</displayy>
<displaywidth>120</displaywidth>
<displayheight>30</displayheight>
</stage>
<stage stageid="3596eb65-1f27-439f-aad3-3da420a8078d" name="Success?" type="Decision">
<subsheetid>a05c17eb-69e9-4f1e-b50c-cc1c353eef22</subsheetid>
<loginhibit />
<decision expression="[Success]" />
<ontrue>51a80d5e-ed7d-43bc-96c9-118c71f92637</ontrue>
<onfalse>3282ef5a-d68c-4ed7-8307-d6c0e2d1515b</onfalse>
<displayx>15</displayx>
<displayy>-15</displayy>
</stage>
<stage stageid="51a80d5e-ed7d-43bc-96c9-118c71f92637" name="Get Data Table" type="Code">
<subsheetid>a05c17eb-69e9-4f1e-b50c-cc1c353eef22</subsheetid>
<loginhibit />
<inputs>
<input type="text" name="SQL" expr="[SQL]" />
</inputs>
<outputs>
<output type="flag" name="Success" stage="Success" />
<output type="text" name="Message" stage="Message" />
<output type="collection" name="Results" stage="Results" />
</outputs>
<onsuccess>08606669-e6ea-47f0-acb8-969844af72d8</onsuccess>
<code><![CDATA[
// Assume success
Success = true;
Message = "";
Results = null;
try
{
using (OracleCommand cmd = new OracleCommand())
{
cmd.Connection = moConnection;
cmd.Transaction = moTransaction;
cmd.CommandText = SQL;
using (OracleDataAdapter adapter = new OracleDataAdapter())
{
adapter.SelectCommand = cmd;
DataSet ds = new DataSet();
adapter.Fill(ds);
Results = ds.Tables[0];
}
}
}
catch (Exception ex)
{
Success = false;
Message = ex.Message;
}]]></code>
<displayx>15</displayx>
<displayy>45</displayy>
</stage>
<stage stageid="08606669-e6ea-47f0-acb8-969844af72d8" name="In Transaction?" type="Decision">
<subsheetid>a05c17eb-69e9-4f1e-b50c-cc1c353eef22</subsheetid>
<loginhibit />
<decision expression="[In Transaction]" />
<ontrue>7239b88e-d964-400e-80f5-6ca9075ac40f</ontrue>
<onfalse>37376e9b-7fe2-4810-bbae-c8e516aebace</onfalse>
<displayx>15</displayx>
<displayy>105</displayy>
</stage>
<stage stageid="7239b88e-d964-400e-80f5-6ca9075ac40f" name="Raise Exception If Appropriate" type="SubSheet">
<subsheetid>a05c17eb-69e9-4f1e-b50c-cc1c353eef22</subsheetid>
<loginhibit />
<inputs>
<input type="flag" name="Success" friendlyname="Success" expr="[Success]" />
<input type="text" name="Error Message" friendlyname="Error Message" expr="[Message]" />
</inputs>
<onsuccess>4f5ac921-1a02-42f0-880d-2206482112c8</onsuccess>
<processid>88b62fd7-41a8-4bc7-806a-bd8e1b5497ca</processid>
<displayx>15</displayx>
<displayy>165</displayy>
</stage>
<stage stageid="37376e9b-7fe2-4810-bbae-c8e516aebace" name="Internal Close" type="SubSheet">
<subsheetid>a05c17eb-69e9-4f1e-b50c-cc1c353eef22</subsheetid>
<loginhibit />
<inputs>
<input type="flag" name="Clear Pool" friendlyname="Clear Pool" expr="False" />
</inputs>
<outputs>
<output type="flag" name="Success" friendlyname="Success" stage="Close Success" />
<output type="text" name="Message" friendlyname="Message" stage="Close Message" />
</outputs>
<onsuccess>2b46f726-d781-487f-8895-e751d6767902</onsuccess>
<processid>f64b457a-dfb7-4200-9a9f-5dd147561478</processid>
<displayx>105</displayx>
<displayy>105</displayy>
</stage>
<stage stageid="3282ef5a-d68c-4ed7-8307-d6c0e2d1515b" name="Anchor23" type="Anchor">
<subsheetid>a05c17eb-69e9-4f1e-b50c-cc1c353eef22</subsheetid>
<loginhibit />
<onsuccess>2b46f726-d781-487f-8895-e751d6767902</onsuccess>
<displayx>165</displayx>
<displayy>-15</displayy>
<displaywidth>10</displaywidth>
<displayheight>10</displayheight>
</stage>
<stage stageid="2b46f726-d781-487f-8895-e751d6767902" name="Anchor24" type="Anchor">
<subsheetid>a05c17eb-69e9-4f1e-b50c-cc1c353eef22</subsheetid>
<loginhibit />
<onsuccess>f16519c7-17cc-406f-b017-3b55cf4cd2a5</onsuccess>
<displayx>165</displayx>
<displayy>105</displayy>
<displaywidth>10</displaywidth>
<displayheight>10</displayheight>
</stage>
<stage stageid="f16519c7-17cc-406f-b017-3b55cf4cd2a5" name="Anchor25" type="Anchor">
<subsheetid>a05c17eb-69e9-4f1e-b50c-cc1c353eef22</subsheetid>
<loginhibit />
<onsuccess>7239b88e-d964-400e-80f5-6ca9075ac40f</onsuccess>
<displayx>165</displayx>
<displayy>165</displayy>
<displaywidth>10</displaywidth>
<displayheight>10</displayheight>
</stage>
<stage stageid="54a70279-2410-42a4-84e2-69deb4c0c4bb" name="Results" type="Collection">
<subsheetid>a05c17eb-69e9-4f1e-b50c-cc1c353eef22</subsheetid>
<loginhibit />
<datatype>collection</datatype>
<private />
<alwaysinit />
<displayx>-195</displayx>
<displayy>150</displayy>
<displaywidth>120</displaywidth>
<displayheight>30</displayheight>
</stage>
<stage stageid="f1f60548-a3e8-4af9-94b4-502b4fc29570" name="Get CSV File" type="SubSheetInfo">
<subsheetid>4e9c1383-a686-4fbc-9e3c-c11c8ade88af</subsheetid>
<narrative>This function takes a valid SQL Select query and returns the results to a CSV (Comma Separated Variable) file.</narrative>
<displayx>-180</displayx>
<displayy>-105</displayy>
<displaywidth>180</displaywidth>
<displayheight>60</displayheight>
</stage>
<stage stageid="7e46716f-1703-49a3-bc61-1e2ac3ab6bb6" name="Start" type="Start">
<subsheetid>4e9c1383-a686-4fbc-9e3c-c11c8ade88af</subsheetid>
<loginhibit />
<inputs>
<input type="text" name="SelectQuery" stage="SQL" />
<input type="text" name="CSVFilename" stage="File" />
</inputs>
<onsuccess>388c8194-db84-4531-a96c-771cf32e890c</onsuccess>
<displayx>15</displayx>
<displayy>-135</displayy>
</stage>
<stage stageid="e43d906f-9435-4acd-8c86-fa305ba62e2e" name="End" type="End">
<subsheetid>4e9c1383-a686-4fbc-9e3c-c11c8ade88af</subsheetid>
<loginhibit />
<outputs>
<output type="flag" name="Success" stage="Success" />
<output type="text" name="Message" stage="Message" />
</outputs>
<displayx>15</displayx>
<displayy>225</displayy>
</stage>
<stage stageid="388c8194-db84-4531-a96c-771cf32e890c" name="Open" type="SubSheet">
<subsheetid>4e9c1383-a686-4fbc-9e3c-c11c8ade88af</subsheetid>
<loginhibit />
<outputs>
<output type="flag" name="Success" friendlyname="Success" stage="Success" />
<output type="text" name="Message" friendlyname="Message" stage="Message" />
</outputs>
<onsuccess>cefc8354-fed0-4b02-9e2f-aaa3a15f03cd</onsuccess>
<processid>d7f92fab-b3c7-4c06-ae2d-503e20b73fd7</processid>
<displayx>15</displayx>
<displayy>-75</displayy>
</stage>
<stage stageid="7db05087-75a4-4edf-96cd-ddc0222ebe27" name="Success" type="Data">
<subsheetid>4e9c1383-a686-4fbc-9e3c-c11c8ade88af</subsheetid>
<loginhibit />
<datatype>flag</datatype>
<initialvalue>False</initialvalue>
<private />
<alwaysinit />
<displayx>-225</displayx>
<displayy>225</displayy>
</stage>
<stage stageid="aca72eb6-3be1-470e-b282-c67bde93d6e9" name="Message" type="Data">
<subsheetid>4e9c1383-a686-4fbc-9e3c-c11c8ade88af</subsheetid>
<loginhibit />
<datatype>text</datatype>
<initialvalue />
<private />
<alwaysinit />
<displayx>-135</displayx>
<displayy>225</displayy>
</stage>
<stage stageid="53b013fa-bedd-4d88-9c02-4c080c3a323c" name="Close Success" type="Data">
<subsheetid>4e9c1383-a686-4fbc-9e3c-c11c8ade88af</subsheetid>
<datatype>flag</datatype>
<initialvalue />
<private />
<alwaysinit />
<displayx>-180</displayx>
<displayy>105</displayy>
<displaywidth>120</displaywidth>
<displayheight>30</displayheight>
</stage>
<stage stageid="5b093c48-7891-4d13-a4e2-74e28839fb92" name="Close Message" type="Data">
<subsheetid>4e9c1383-a686-4fbc-9e3c-c11c8ade88af</subsheetid>
<datatype>text</datatype>
<initialvalue />
<private />
<alwaysinit />
<displayx>-180</displayx>
<displayy>150</displayy>
<displaywidth>120</displaywidth>
<displayheight>30</displayheight>
</stage>
<stage stageid="6bfdb20b-8146-4da3-8e57-1699f20c1182" name="SQL" type="Data">
<subsheetid>4e9c1383-a686-4fbc-9e3c-c11c8ade88af</subsheetid>
<loginhibit />
<datatype>text</datatype>
<initialvalue />
<private />
<alwaysinit />
<displayx>-180</displayx>
<displayy>-15</displayy>
<displaywidth>120</displaywidth>
<displayheight>30</displayheight>
</stage>
<stage stageid="cefc8354-fed0-4b02-9e2f-aaa3a15f03cd" name="Success?" type="Decision">
<subsheetid>4e9c1383-a686-4fbc-9e3c-c11c8ade88af</subsheetid>
<loginhibit />
<decision expression="[Success]" />
<ontrue>66114a6f-b706-42a9-a932-1a5fc4891b3f</ontrue>
<onfalse>43cf3da7-04f9-4c2f-a8eb-9f6819d6b8ca</onfalse>
<displayx>15</displayx>
<displayy>-15</displayy>
</stage>
<stage stageid="66114a6f-b706-42a9-a932-1a5fc4891b3f" name="Get CSV File" type="Code">
<subsheetid>4e9c1383-a686-4fbc-9e3c-c11c8ade88af</subsheetid>
<loginhibit />
<inputs>
<input type="text" name="SQL" expr="[SQL]" />
<input type="text" name="File" expr="[File]" />
</inputs>
<outputs>
<output type="flag" name="Success" stage="Success" />
<output type="text" name="Message" stage="Message" />
</outputs>
<onsuccess>fd8fc231-698c-428c-b4ed-7431456df3e2</onsuccess>
<code><![CDATA[// Assume success
Success = true;
Message = "";
try
{
// Write it out using the method in Global Code
using (StreamWriter sw = new StreamWriter(File, false))
{
WriteCsv(SQL, sw);
}
}
catch (Exception ex)
{
Success = false;
Message = ex.Message;
}
]]></code>
<displayx>15</displayx>
<displayy>45</displayy>
</stage>
<stage stageid="fd8fc231-698c-428c-b4ed-7431456df3e2" name="In Transaction?" type="Decision">
<subsheetid>4e9c1383-a686-4fbc-9e3c-c11c8ade88af</subsheetid>
<loginhibit />
<decision expression="[In Transaction]" />
<ontrue>e9fd0d92-adc6-4fb4-bf55-0e454fc4246d</ontrue>
<onfalse>613c3098-d8ed-42d2-b652-380ceb778b4f</onfalse>
<displayx>15</displayx>
<displayy>105</displayy>
</stage>
<stage stageid="e9fd0d92-adc6-4fb4-bf55-0e454fc4246d" name="Raise Exception If Appropriate" type="SubSheet">
<subsheetid>4e9c1383-a686-4fbc-9e3c-c11c8ade88af</subsheetid>
<loginhibit />
<inputs>
<input type="flag" name="Success" friendlyname="Success" expr="[Success]" />
<input type="text" name="Error Message" friendlyname="Error Message" expr="[Message]" />
</inputs>
<onsuccess>e43d906f-9435-4acd-8c86-fa305ba62e2e</onsuccess>
<processid>88b62fd7-41a8-4bc7-806a-bd8e1b5497ca</processid>
<displayx>15</displayx>
<displayy>165</displayy>
</stage>
<stage stageid="613c3098-d8ed-42d2-b652-380ceb778b4f" name="Internal Close" type="SubSheet">
<subsheetid>4e9c1383-a686-4fbc-9e3c-c11c8ade88af</subsheetid>
<loginhibit />
<inputs>
<input type="flag" name="Clear Pool" friendlyname="Clear Pool" expr="False" />
</inputs>
<outputs>
<output type="flag" name="Success" friendlyname="Success" stage="Close Success" />
<output type="text" name="Message" friendlyname="Message" stage="Close Message" />
</outputs>
<onsuccess>63ed4515-04b7-453f-96fc-2c7c6314af4c</onsuccess>
<processid>f64b457a-dfb7-4200-9a9f-5dd147561478</processid>
<displayx>105</displayx>
<displayy>105</displayy>
</stage>
<stage stageid="43cf3da7-04f9-4c2f-a8eb-9f6819d6b8ca" name="Anchor23" type="Anchor">
<subsheetid>4e9c1383-a686-4fbc-9e3c-c11c8ade88af</subsheetid>
<loginhibit />
<onsuccess>63ed4515-04b7-453f-96fc-2c7c6314af4c</onsuccess>
<displayx>165</displayx>
<displayy>-15</displayy>
<displaywidth>10</displaywidth>
<displayheight>10</displayheight>
</stage>
<stage stageid="63ed4515-04b7-453f-96fc-2c7c6314af4c" name="Anchor24" type="Anchor">
<subsheetid>4e9c1383-a686-4fbc-9e3c-c11c8ade88af</subsheetid>
<loginhibit />
<onsuccess>71fca5d6-6b2f-4874-90d0-942f08b2410e</onsuccess>
<displayx>165</displayx>
<displayy>105</displayy>
<displaywidth>10</displaywidth>
<displayheight>10</displayheight>
</stage>
<stage stageid="71fca5d6-6b2f-4874-90d0-942f08b2410e" name="Anchor25" type="Anchor">
<subsheetid>4e9c1383-a686-4fbc-9e3c-c11c8ade88af</subsheetid>
<loginhibit />
<onsuccess>e9fd0d92-adc6-4fb4-bf55-0e454fc4246d</onsuccess>
<displayx>165</displayx>
<displayy>165</displayy>
<displaywidth>10</displaywidth>
<displayheight>10</displayheight>
</stage>
<stage stageid="b8217d62-774b-47d5-81ec-c80ba861bb63" name="File" type="Data">
<subsheetid>4e9c1383-a686-4fbc-9e3c-c11c8ade88af</subsheetid>
<loginhibit />
<datatype>text</datatype>
<initialvalue />
<private />
<alwaysinit />
<displayx>-180</displayx>
<displayy>30</displayy>
<displaywidth>90</displaywidth>
<displayheight>30</displayheight>
</stage>
<stage stageid="47d70e00-0344-4eb2-8bc6-322b0c100156" name="Get CSV" type="SubSheetInfo">
<subsheetid>d2d014d5-71ff-47d1-8a2d-adf47aa96ab6</subsheetid>
<narrative>This function takes a valid SQL Select query and returns the results to a string in comma separated format. </narrative>
<displayx>-195</displayx>
<displayy>-105</displayy>
<displaywidth>150</displaywidth>
<displayheight>90</displayheight>
</stage>
<stage stageid="aaf2dd48-b47a-4ab8-8e21-37ae7eafeabc" name="Start" type="Start">
<subsheetid>d2d014d5-71ff-47d1-8a2d-adf47aa96ab6</subsheetid>
<loginhibit />
<inputs>
<input type="text" name="SelectQuery" stage="SQL" />
</inputs>
<onsuccess>113c2906-45ac-4a95-9c7f-30bff869064b</onsuccess>
<displayx>15</displayx>
<displayy>-135</displayy>
</stage>
<stage stageid="84e90fc2-6e87-4152-89fb-73b1a4f2fb6a" name="End" type="End">
<subsheetid>d2d014d5-71ff-47d1-8a2d-adf47aa96ab6</subsheetid>
<loginhibit />
<outputs>
<output type="text" name="CSV" stage="CSV" />
<output type="flag" name="Success" stage="Success" />
<output type="text" name="Message" stage="Message" />
</outputs>
<displayx>15</displayx>
<displayy>225</displayy>
</stage>
<stage stageid="113c2906-45ac-4a95-9c7f-30bff869064b" name="Open" type="SubSheet">
<subsheetid>d2d014d5-71ff-47d1-8a2d-adf47aa96ab6</subsheetid>
<loginhibit />
<outputs>
<output type="flag" name="Success" friendlyname="Success" stage="Success" />
<output type="text" name="Message" friendlyname="Message" stage="Message" />
</outputs>
<onsuccess>6666b9d4-5648-48d6-9a1e-3b0d2d020d76</onsuccess>
<processid>d7f92fab-b3c7-4c06-ae2d-503e20b73fd7</processid>
<displayx>15</displayx>
<displayy>-75</displayy>
</stage>
<stage stageid="ed99413c-1906-4e5d-bef6-844fe3a8d453" name="Success" type="Data">
<subsheetid>d2d014d5-71ff-47d1-8a2d-adf47aa96ab6</subsheetid>
<loginhibit />
<datatype>flag</datatype>
<initialvalue>False</initialvalue>
<private />
<alwaysinit />
<displayx>-195</displayx>
<displayy>60</displayy>
<displaywidth>120</displaywidth>
<displayheight>30</displayheight>
</stage>
<stage stageid="2d2c4937-a5e4-4a73-a8c8-071013a88686" name="Message" type="Data">
<subsheetid>d2d014d5-71ff-47d1-8a2d-adf47aa96ab6</subsheetid>
<loginhibit />
<datatype>text</datatype>
<initialvalue />
<private />
<alwaysinit />
<displayx>-195</displayx>
<displayy>105</displayy>
<displaywidth>120</displaywidth>
<displayheight>30</displayheight>
</stage>
<stage stageid="2904d2e1-454f-486c-a0a9-f3b131d9ab50" name="Close Success" type="Data">
<subsheetid>d2d014d5-71ff-47d1-8a2d-adf47aa96ab6</subsheetid>
<datatype>flag</datatype>
<initialvalue />
<private />
<alwaysinit />
<displayx>-195</displayx>
<displayy>225</displayy>
<displaywidth>120</displaywidth>
<displayheight>30</displayheight>
</stage>
<stage stageid="af2270b8-1faf-4c9e-b465-7ebcb175469d" name="Close Message" type="Data">
<subsheetid>d2d014d5-71ff-47d1-8a2d-adf47aa96ab6</subsheetid>
<datatype>text</datatype>
<initialvalue />
<private />
<alwaysinit />
<displayx>-195</displayx>
<displayy>270</displayy>
<displaywidth>120</displaywidth>
<displayheight>30</displayheight>
</stage>
<stage stageid="311bbf48-96a2-4b75-b14e-d07b01c7e063" name="SQL" type="Data">
<subsheetid>d2d014d5-71ff-47d1-8a2d-adf47aa96ab6</subsheetid>
<loginhibit />
<datatype>text</datatype>
<initialvalue />
<private />
<alwaysinit />
<displayx>-195</displayx>
<displayy>-15</displayy>
<displaywidth>120</displaywidth>
<displayheight>30</displayheight>
</stage>
<stage stageid="6666b9d4-5648-48d6-9a1e-3b0d2d020d76" name="Success?" type="Decision">
<subsheetid>d2d014d5-71ff-47d1-8a2d-adf47aa96ab6</subsheetid>
<loginhibit />
<decision expression="[Success]" />
<ontrue>64e864ea-1b10-4a6e-95af-0e0a3fe0628d</ontrue>
<onfalse>ef26ed02-b966-4f1b-b84d-2c9e912133de</onfalse>
<displayx>15</displayx>
<displayy>-15</displayy>
</stage>
<stage stageid="64e864ea-1b10-4a6e-95af-0e0a3fe0628d" name="Get CSV" type="Code">
<subsheetid>d2d014d5-71ff-47d1-8a2d-adf47aa96ab6</subsheetid>
<loginhibit />
<inputs>
<input type="text" name="SQL" expr="[SQL]" />
</inputs>
<outputs>
<output type="flag" name="Success" stage="Success" />
<output type="text" name="Message" stage="Message" />
<output type="text" name="CSV" stage="CSV" />
</outputs>
<onsuccess>fa17e58a-8fe4-4953-9d42-f6fe8b42bf71</onsuccess>
<code><![CDATA[// Assume success
Success = true;
Message = "";
CSV= string.Empty;
try
{
// Write it out using the method in Global Code
using (StringWriter sw = new StringWriter())
{
WriteCsv(SQL, sw);
CSV = sw.ToString();
}
}
catch (Exception ex)
{
Success = false;
Message = ex.Message;
}]]></code>
<displayx>15</displayx>
<displayy>45</displayy>
</stage>
<stage stageid="fa17e58a-8fe4-4953-9d42-f6fe8b42bf71" name="In Transaction?" type="Decision">
<subsheetid>d2d014d5-71ff-47d1-8a2d-adf47aa96ab6</subsheetid>
<loginhibit />
<decision expression="[In Transaction]" />
<ontrue>f733dbe1-b8d8-481c-bb02-fae9eed564df</ontrue>
<onfalse>a45065ea-6cbf-492b-acb4-ced63a2c86d2</onfalse>
<displayx>15</displayx>
<displayy>105</displayy>
</stage>
<stage stageid="f733dbe1-b8d8-481c-bb02-fae9eed564df" name="Raise Exception If Appropriate" type="SubSheet">
<subsheetid>d2d014d5-71ff-47d1-8a2d-adf47aa96ab6</subsheetid>
<loginhibit />
<inputs>
<input type="flag" name="Success" friendlyname="Success" expr="[Success]" />
<input type="text" name="Error Message" friendlyname="Error Message" expr="[Message]" />
</inputs>
<onsuccess>84e90fc2-6e87-4152-89fb-73b1a4f2fb6a</onsuccess>
<processid>88b62fd7-41a8-4bc7-806a-bd8e1b5497ca</processid>
<displayx>15</displayx>
<displayy>165</displayy>
</stage>
<stage stageid="a45065ea-6cbf-492b-acb4-ced63a2c86d2" name="Internal Close" type="SubSheet">
<subsheetid>d2d014d5-71ff-47d1-8a2d-adf47aa96ab6</subsheetid>
<loginhibit />
<inputs>
<input type="flag" name="Clear Pool" friendlyname="Clear Pool" expr="False" />
</inputs>
<outputs>
<output type="flag" name="Success" friendlyname="Success" stage="Close Success" />
<output type="text" name="Message" friendlyname="Message" stage="Close Message" />
</outputs>
<onsuccess>5747aa0b-297d-4eb5-908e-5885a55ca3c7</onsuccess>
<processid>f64b457a-dfb7-4200-9a9f-5dd147561478</processid>
<displayx>105</displayx>
<displayy>105</displayy>
</stage>
<stage stageid="ef26ed02-b966-4f1b-b84d-2c9e912133de" name="Anchor23" type="Anchor">
<subsheetid>d2d014d5-71ff-47d1-8a2d-adf47aa96ab6</subsheetid>
<loginhibit />
<onsuccess>5747aa0b-297d-4eb5-908e-5885a55ca3c7</onsuccess>
<displayx>165</displayx>
<displayy>-15</displayy>
<displaywidth>10</displaywidth>
<displayheight>10</displayheight>
</stage>
<stage stageid="5747aa0b-297d-4eb5-908e-5885a55ca3c7" name="Anchor24" type="Anchor">
<subsheetid>d2d014d5-71ff-47d1-8a2d-adf47aa96ab6</subsheetid>
<loginhibit />
<onsuccess>a8653c1c-8515-4275-9b7d-5f6408af6c8e</onsuccess>
<displayx>165</displayx>
<displayy>105</displayy>
<displaywidth>10</displaywidth>
<displayheight>10</displayheight>
</stage>
<stage stageid="a8653c1c-8515-4275-9b7d-5f6408af6c8e" name="Anchor25" type="Anchor">
<subsheetid>d2d014d5-71ff-47d1-8a2d-adf47aa96ab6</subsheetid>
<loginhibit />
<onsuccess>f733dbe1-b8d8-481c-bb02-fae9eed564df</onsuccess>
<displayx>165</displayx>
<displayy>165</displayy>
<displaywidth>10</displaywidth>
<displayheight>10</displayheight>
</stage>
<stage stageid="92d6f32d-4b93-44bb-a6a7-309854ffd9f9" name="CSV" type="Data">
<subsheetid>d2d014d5-71ff-47d1-8a2d-adf47aa96ab6</subsheetid>
<loginhibit />
<datatype>text</datatype>
<initialvalue />
<private />
<alwaysinit />
<displayx>-195</displayx>
<displayy>150</displayy>
<displaywidth>90</displaywidth>
<displayheight>30</displayheight>
</stage>
<stage stageid="a9084396-228d-4ea5-88bf-61729de91032" name="Get User Name" type="SubSheetInfo">
<subsheetid>43d80e10-0a8d-46f4-abcb-19fcbd68fc6b</subsheetid>
<narrative>This function returns the currently logged on user. This is an environment value and not a value from Oracle. </narrative>
<displayx>-195</displayx>
<displayy>-105</displayy>
<displaywidth>150</displaywidth>
<displayheight>90</displayheight>
</stage>
<stage stageid="922400e9-6d29-4118-9ed5-f2bc230db283" name="Start" type="Start">
<subsheetid>43d80e10-0a8d-46f4-abcb-19fcbd68fc6b</subsheetid>
<loginhibit />
<onsuccess>8ffc9cf0-b802-4d60-8aec-de10b8f0b0d0</onsuccess>
<displayx>-45</displayx>
<displayy>-120</displayy>
</stage>
<stage stageid="a4ee627b-6d62-4671-acde-20e0ae9aeb81" name="End" type="End">
<subsheetid>43d80e10-0a8d-46f4-abcb-19fcbd68fc6b</subsheetid>
<loginhibit />
<outputs>
<output type="text" name="user name" stage="user name" />
</outputs>
<displayx>-45</displayx>
<displayy>30</displayy>
</stage>
<stage stageid="8ffc9cf0-b802-4d60-8aec-de10b8f0b0d0" name="get user name" type="Code">
<subsheetid>43d80e10-0a8d-46f4-abcb-19fcbd68fc6b</subsheetid>
<loginhibit />
<outputs>
<output type="text" name="user name" stage="user name" />
</outputs>
<onsuccess>a4ee627b-6d62-4671-acde-20e0ae9aeb81</onsuccess>
<code><![CDATA[
user_name = System.Environment.UserName;]]></code>
<displayx>-45</displayx>
<displayy>-45</displayy>
<displaywidth>90</displaywidth>
<displayheight>60</displayheight>
</stage>
<stage stageid="4ee86802-c16f-40c2-b7b9-bd5cf17bd707" name="user name" type="Data">
<subsheetid>43d80e10-0a8d-46f4-abcb-19fcbd68fc6b</subsheetid>
<loginhibit />
<datatype>text</datatype>
<initialvalue />
<private />
<alwaysinit />
<displayx>-195</displayx>
<displayy>0</displayy>
<displaywidth>120</displaywidth>
<displayheight>30</displayheight>
</stage>
<stage stageid="b714d785-c9f5-4972-9f5f-6b4607eee3a0" name="Get Machine Name" type="SubSheetInfo">
<subsheetid>5c204a77-ccc6-45cd-a3be-936abb251c49</subsheetid>
<narrative>This function returns the value of the current machine name where the user is logged on to. This is not a value from Oracle. </narrative>
<displayx>-195</displayx>
<displayy>-105</displayy>
<displaywidth>150</displaywidth>
<displayheight>90</displayheight>
</stage>
<stage stageid="45d5c6f9-071f-4280-a9c2-6c132b629bb9" name="Start" type="Start">
<subsheetid>5c204a77-ccc6-45cd-a3be-936abb251c49</subsheetid>
<loginhibit />
<onsuccess>03f3bcd3-9a22-4e4b-94bc-70a894c4707c</onsuccess>
<displayx>15</displayx>
<displayy>-105</displayy>
</stage>
<stage stageid="5b285524-8427-471c-8eb8-605a7cd5e029" name="End" type="End">
<subsheetid>5c204a77-ccc6-45cd-a3be-936abb251c49</subsheetid>
<loginhibit />
<outputs>
<output type="text" name="machine name" stage="machine name" />
</outputs>
<displayx>15</displayx>
<displayy>45</displayy>
</stage>
<stage stageid="03f3bcd3-9a22-4e4b-94bc-70a894c4707c" name="get machine name" type="Code">
<subsheetid>5c204a77-ccc6-45cd-a3be-936abb251c49</subsheetid>
<loginhibit />
<outputs>
<output type="text" name="machine name" stage="machine name" />
</outputs>
<onsuccess>5b285524-8427-471c-8eb8-605a7cd5e029</onsuccess>
<code><![CDATA[
machine_name = System.Environment.MachineName;]]></code>
<displayx>15</displayx>
<displayy>-30</displayy>
<displaywidth>90</displaywidth>
<displayheight>30</displayheight>
</stage>
<stage stageid="5c058ae3-6624-4019-bfe5-b5f2a5188842" name="machine name" type="Data">
<subsheetid>5c204a77-ccc6-45cd-a3be-936abb251c49</subsheetid>
<loginhibit />
<datatype>text</datatype>
<initialvalue />
<private />
<alwaysinit />
<displayx>-195</displayx>
<displayy>0</displayy>
<displaywidth>120</displaywidth>
<displayheight>30</displayheight>
</stage>
<stage stageid="493e2ecd-c1a5-4938-83c2-af9eaa3e078a" name="Drop Table" type="SubSheetInfo">
<subsheetid>15d519d8-1803-4720-821c-3ccea40d8273</subsheetid>
<narrative>This function takes table name and executes an SQL statement to drop the table. This is a destructive action. This function requires some database schema knowledge.</narrative>
<displayx>-195</displayx>
<displayy>-105</displayy>
<displaywidth>150</displaywidth>
<displayheight>90</displayheight>
</stage>
<stage stageid="484b96dd-f9d3-47c3-8c96-09d8665088e4" name="Start" type="Start">
<subsheetid>15d519d8-1803-4720-821c-3ccea40d8273</subsheetid>
<loginhibit />
<inputs>
<input type="text" name="TableToDrop" stage="TableToDrop" />
<input type="flag" name="ReportExceptions" stage="ReportExceptions" />
</inputs>
<onsuccess>29a0807c-b1e3-4a45-952a-c9bbb695a633</onsuccess>
<displayx>15</displayx>
<displayy>-105</displayy>
</stage>
<stage stageid="973f071b-5bef-432d-9407-d85c1eb63722" name="End" type="End">
<subsheetid>15d519d8-1803-4720-821c-3ccea40d8273</subsheetid>
<loginhibit />
<outputs>
<output type="flag" name="Success" stage="Success" />
<output type="text" name="Message" stage="Message" />
</outputs>
<displayx>15</displayx>
<displayy>15</displayy>
</stage>
<stage stageid="b95942b8-55cf-4f5a-b14b-cf5d9ad9fb25" name="TableToDrop" type="Data">
<subsheetid>15d519d8-1803-4720-821c-3ccea40d8273</subsheetid>
<datatype>text</datatype>
<initialvalue />
<private />
<alwaysinit />
<displayx>-195</displayx>
<displayy>30</displayy>
<displaywidth>90</displaywidth>
<displayheight>30</displayheight>
</stage>
<stage stageid="3cc6742e-c70c-4919-9d3f-82f0394ad3bc" name="ReportExceptions" type="Data">
<subsheetid>15d519d8-1803-4720-821c-3ccea40d8273</subsheetid>
<datatype>flag</datatype>
<initialvalue />
<private />
<alwaysinit />
<displayx>-195</displayx>
<displayy>-15</displayy>
<displaywidth>90</displaywidth>
<displayheight>30</displayheight>
</stage>
<stage stageid="29a0807c-b1e3-4a45-952a-c9bbb695a633" name="Execute" type="SubSheet">
<subsheetid>15d519d8-1803-4720-821c-3ccea40d8273</subsheetid>
<loginhibit />
<inputs>
<input type="text" name="Query" friendlyname="Query" expr="&quot;DROP TABLE &quot; &amp; [TableToDrop]" />
</inputs>
<outputs>
<output type="flag" name="Success" friendlyname="Success" stage="Success" />
<output type="text" name="Message" friendlyname="Message" stage="Message" />
<output type="number" name="RecordsAffected" friendlyname="RecordsAffected" stage="Records Affected" />
</outputs>
<onsuccess>973f071b-5bef-432d-9407-d85c1eb63722</onsuccess>
<processid>540e741c-c8b3-4b39-9574-4abc24bd8bc9</processid>
<displayx>15</displayx>
<displayy>-45</displayy>
</stage>
<stage stageid="e107f897-cd9c-4555-b1ce-4617ab49c115" name="Success" type="Data">
<subsheetid>15d519d8-1803-4720-821c-3ccea40d8273</subsheetid>
<datatype>flag</datatype>
<initialvalue />
<private />
<alwaysinit />
<displayx>-195</displayx>
<displayy>150</displayy>
</stage>
<stage stageid="ce026706-4407-4d30-9ce6-09d48badfb34" name="Message" type="Data">
<subsheetid>15d519d8-1803-4720-821c-3ccea40d8273</subsheetid>
<datatype>text</datatype>
<initialvalue />
<private />
<alwaysinit />
<displayx>-195</displayx>
<displayy>105</displayy>
</stage>
<stage stageid="69d94c6d-f9aa-4086-a8cb-e44546109cd1" name="Drop Table" type="SubSheetInfo">
<subsheetid>ba1c8e81-ef16-4940-a993-09fe604cda76</subsheetid>
<narrative>This removes the complete set of rows in a table. This function requires some database schema knowledge. </narrative>
<displayx>-195</displayx>
<displayy>-105</displayy>
<displaywidth>150</displaywidth>
<displayheight>90</displayheight>
</stage>
<stage stageid="94d7cda4-dcf7-467a-95d0-34ae7832a6db" name="Start" type="Start">
<subsheetid>ba1c8e81-ef16-4940-a993-09fe604cda76</subsheetid>
<loginhibit />
<inputs>
<input type="text" name="TableToTruncate" stage="TableToTruncate" />
</inputs>
<onsuccess>79f2e688-1138-4bfc-96ea-a97be9ee5062</onsuccess>
<displayx>15</displayx>
<displayy>-105</displayy>
</stage>
<stage stageid="810653df-7002-483e-bd15-388d2bd7b173" name="End" type="End">
<subsheetid>ba1c8e81-ef16-4940-a993-09fe604cda76</subsheetid>
<loginhibit />
<outputs>
<output type="flag" name="Success" stage="Success" />
<output type="text" name="Message" stage="Message" />
</outputs>
<displayx>15</displayx>
<displayy>15</displayy>
</stage>
<stage stageid="7a53a4fe-28f2-4e30-9ad5-de289bc1fd79" name="TableToTruncate" type="Data">
<subsheetid>ba1c8e81-ef16-4940-a993-09fe604cda76</subsheetid>
<datatype>text</datatype>
<initialvalue />
<private />
<alwaysinit />
<displayx>-195</displayx>
<displayy>-15</displayy>
<displaywidth>90</displaywidth>
<displayheight>30</displayheight>
</stage>
<stage stageid="79f2e688-1138-4bfc-96ea-a97be9ee5062" name="Execute" type="SubSheet">
<subsheetid>ba1c8e81-ef16-4940-a993-09fe604cda76</subsheetid>
<loginhibit />
<inputs>
<input type="text" name="Query" friendlyname="Query" expr="&quot;TRUNCATE TABLE &quot; &amp; [TableToTruncate]" />
</inputs>
<outputs>
<output type="flag" name="Success" friendlyname="Success" stage="Success" />
<output type="text" name="Message" friendlyname="Message" stage="Message" />
<output type="number" name="RecordsAffected" friendlyname="RecordsAffected" stage="Records Affected" />
</outputs>
<onsuccess>810653df-7002-483e-bd15-388d2bd7b173</onsuccess>
<processid>540e741c-c8b3-4b39-9574-4abc24bd8bc9</processid>
<displayx>15</displayx>
<displayy>-45</displayy>
</stage>
<stage stageid="435e7785-a545-4395-91bf-0355024a68c2" name="Success" type="Data">
<subsheetid>ba1c8e81-ef16-4940-a993-09fe604cda76</subsheetid>
<datatype>flag</datatype>
<initialvalue />
<private />
<alwaysinit />
<displayx>-195</displayx>
<displayy>105</displayy>
</stage>
<stage stageid="f805e453-4b1e-45b0-be17-2d48feb51acf" name="Message" type="Data">
<subsheetid>ba1c8e81-ef16-4940-a993-09fe604cda76</subsheetid>
<datatype>text</datatype>
<initialvalue />
<private />
<alwaysinit />
<displayx>-195</displayx>
<displayy>60</displayy>
</stage>
<stage stageid="ca054251-6198-49fe-b2a1-42939e115a68" name="Delete Rows - Where" type="SubSheetInfo">
<subsheetid>379163bf-d2ab-47d2-9132-1827ccf80e66</subsheetid>
<narrative>This function will delete a set of records from a table where the where clause is satisfied. This function requires some database schema knowledge.</narrative>
<displayx>-195</displayx>
<displayy>-105</displayy>
<displaywidth>150</displaywidth>
<displayheight>90</displayheight>
</stage>
<stage stageid="04dfc9d1-c6bb-4d46-adf3-c8a99e64e0b8" name="Start" type="Start">
<subsheetid>379163bf-d2ab-47d2-9132-1827ccf80e66</subsheetid>
<loginhibit />
<inputs>
<input type="text" name="TableToDeleteFrom" stage="TableToDeleteFrom" />
<input type="text" name="WhereClause" stage="WhereClause" />
</inputs>
<onsuccess>a0ca44e4-5160-46ce-b265-d4c17d48dc29</onsuccess>
<displayx>15</displayx>
<displayy>-105</displayy>
</stage>
<stage stageid="e5d21f2c-63ed-4102-ad19-bf32e7c1322d" name="End" type="End">
<subsheetid>379163bf-d2ab-47d2-9132-1827ccf80e66</subsheetid>
<loginhibit />
<outputs>
<output type="flag" name="Success" stage="Success" />
<output type="text" name="Message" stage="Message" />
</outputs>
<displayx>15</displayx>
<displayy>15</displayy>
</stage>
<stage stageid="b6a50871-f92f-4245-a580-975eb4385400" name="TableToDeleteFrom" type="Data">
<subsheetid>379163bf-d2ab-47d2-9132-1827ccf80e66</subsheetid>
<datatype>text</datatype>
<initialvalue />
<private />
<alwaysinit />
<displayx>-195</displayx>
<displayy>-15</displayy>
<displaywidth>120</displaywidth>
<displayheight>30</displayheight>
</stage>
<stage stageid="bb2cb85f-45e9-4cae-b65b-c6b40ca7c35b" name="WhereClause" type="Data">
<subsheetid>379163bf-d2ab-47d2-9132-1827ccf80e66</subsheetid>
<datatype>text</datatype>
<initialvalue />
<private />
<alwaysinit />
<displayx>-195</displayx>
<displayy>30</displayy>
<displaywidth>120</displaywidth>
<displayheight>30</displayheight>
</stage>
<stage stageid="a0ca44e4-5160-46ce-b265-d4c17d48dc29" name="Execute" type="SubSheet">
<subsheetid>379163bf-d2ab-47d2-9132-1827ccf80e66</subsheetid>
<loginhibit />
<inputs>
<input type="text" name="Query" friendlyname="Query" expr="&quot;DELETE &quot; &amp; [TableToDeleteFrom] &amp; &quot; WHERE &quot; &amp; [WhereClause]" />
</inputs>
<outputs>
<output type="flag" name="Success" friendlyname="Success" stage="Success" />
<output type="text" name="Message" friendlyname="Message" stage="Message" />
<output type="number" name="RecordsAffected" friendlyname="RecordsAffected" stage="Records Affected" />
</outputs>
<onsuccess>e5d21f2c-63ed-4102-ad19-bf32e7c1322d</onsuccess>
<processid>540e741c-c8b3-4b39-9574-4abc24bd8bc9</processid>
<displayx>15</displayx>
<displayy>-45</displayy>
</stage>
<stage stageid="1114554f-6d20-4222-baad-1cc3ce3a3a19" name="Message" type="Data">
<subsheetid>379163bf-d2ab-47d2-9132-1827ccf80e66</subsheetid>
<datatype>text</datatype>
<initialvalue />
<private />
<alwaysinit />
<displayx>-195</displayx>
<displayy>165</displayy>
</stage>
<stage stageid="0ddce3c1-791c-4dd0-b42e-086edcc462ad" name="Success" type="Data">
<subsheetid>379163bf-d2ab-47d2-9132-1827ccf80e66</subsheetid>
<datatype>flag</datatype>
<initialvalue />
<private />
<alwaysinit />
<displayx>-195</displayx>
<displayy>120</displayy>
</stage>
<stage stageid="00698ea1-1f54-4ff3-b569-095808fbd9b0" name="Set Connection" type="SubSheet">
<subsheetid>d7f92fab-b3c7-4c06-ae2d-503e20b73fd7</subsheetid>
<loginhibit />
<inputs>
<input type="text" name="ConnectionName" friendlyname="ConnectionName" expr="[OracleMDA_SID]" />
<input type="text" name="Hostname" friendlyname="Hostname" narrative="The IP address of the oracle host." expr="[OracleMDA_Host]" />
<input type="text" name="Port" friendlyname="Port" narrative="The listening port on the oracle host." expr="[OracleMDA_Port]" />
<input type="text" name="Username" friendlyname="Username" expr="[User]" />
<input type="password" name="Password" friendlyname="Password" expr="[Password]" />
</inputs>
<outputs>
<output type="text" name="ConnectionString" friendlyname="ConnectionString" stage="Connection String" />
</outputs>
<onsuccess>19556310-2b41-422d-af21-e3c6458d1dfe</onsuccess>
<processid>241b279e-d44c-422b-9421-669b95323468</processid>
<displayx>15</displayx>
<displayy>-45</displayy>
</stage>
<stage stageid="b1b3fc2b-0013-4a69-93d3-ef36bf0c00c9" name="Outputs" type="Block">
<subsheetid>4e9c1383-a686-4fbc-9e3c-c11c8ade88af</subsheetid>
<font family="Segoe UI" size="10" style="Regular" color="00FF00" />
<displayx>-270</displayx>
<displayy>195</displayy>
<displaywidth>180</displaywidth>
<displayheight>60</displayheight>
</stage>
<stage stageid="cd401db0-83f6-4e8d-bcc0-30ff6b1e5294" name="Inputs" type="Block">
<subsheetid>4e9c1383-a686-4fbc-9e3c-c11c8ade88af</subsheetid>
<font family="Segoe UI" size="10" style="Regular" color="FFFF00" />
<displayx>-270</displayx>
<displayy>-45</displayy>
<displaywidth>180</displaywidth>
<displayheight>105</displayheight>
</stage>
<stage stageid="5d76db43-3765-4fc2-baba-66381704e8d7" name="Data Items" type="Block">
<subsheetid>4e9c1383-a686-4fbc-9e3c-c11c8ade88af</subsheetid>
<font family="Segoe UI" size="10" style="Regular" color="FFCC00" />
<displayx>-270</displayx>
<displayy>75</displayy>
<displaywidth>180</displaywidth>
<displayheight>105</displayheight>
</stage>
<stage stageid="658c5532-ea64-4c35-99c1-4c216496c717" name="Shared Variables" type="Block">
<loginhibit />
<font family="Segoe UI" size="10" style="Regular" color="FFCC00" />
<displayx>75</displayx>
<displayy>-195</displayy>
<displaywidth>210</displaywidth>
<displayheight>450</displayheight>
</stage>
<stage stageid="7fbfdd25-5539-4074-bec3-5a776d0d295c" name="Inputs" type="Block">
<subsheetid>ccacb83a-6ee1-4fc5-9c2b-d09215a4f561</subsheetid>
<loginhibit />
<font family="Segoe UI" size="10" style="Regular" color="FFFF00" />
<displayx>-300</displayx>
<displayy>-45</displayy>
<displaywidth>210</displaywidth>
<displayheight>60</displayheight>
</stage>
<stage stageid="df685cb9-8376-41d5-a18c-84cf885f614a" name="Outputs" type="Block">
<subsheetid>88b62fd7-41a8-4bc7-806a-bd8e1b5497ca</subsheetid>
<loginhibit />
<font family="Segoe UI" size="10" style="Regular" color="00FF00" />
<displayx>-270</displayx>
<displayy>-15</displayy>
<displaywidth>150</displaywidth>
<displayheight>60</displayheight>
</stage>
<stage stageid="54ef51b6-b100-4fbf-88ce-1ed89b46acbb" name="Data Items" type="Block">
<subsheetid>241b279e-d44c-422b-9421-669b95323468</subsheetid>
<loginhibit />
<font family="Segoe UI" size="10" style="Regular" color="FFCC00" />
<displayx>-270</displayx>
<displayy>-45</displayy>
<displaywidth>150</displaywidth>
<displayheight>90</displayheight>
</stage>
<stage stageid="5025e1c0-28dc-4f28-b53a-b9103aac0716" name="Local Data Items" type="Block">
<subsheetid>f64b457a-dfb7-4200-9a9f-5dd147561478</subsheetid>
<loginhibit />
<font family="Segoe UI" size="10" style="Regular" color="FFCC00" />
<displayx>-255</displayx>
<displayy>75</displayy>
<displaywidth>120</displaywidth>
<displayheight>60</displayheight>
</stage>
<stage stageid="a8f2acdc-e2bc-4680-9b21-df9a6fb29c49" name="Outputs" type="Block">
<subsheetid>f64b457a-dfb7-4200-9a9f-5dd147561478</subsheetid>
<loginhibit />
<font family="Segoe UI" size="10" style="Regular" color="00FF00" />
<displayx>-255</displayx>
<displayy>-45</displayy>
<displaywidth>120</displaywidth>
<displayheight>105</displayheight>
</stage>
<stage stageid="2159e1f9-bd93-43d0-8ce1-a9259a2f3b4e" name="Local Data Items" type="Block">
<subsheetid>bad96847-65f0-40bc-be35-8d593764ca18</subsheetid>
<loginhibit />
<font family="Segoe UI" size="10" style="Regular" color="FFCC00" />
<displayx>-255</displayx>
<displayy>75</displayy>
<displaywidth>120</displaywidth>
<displayheight>60</displayheight>
</stage>
<stage stageid="2283e0ea-2606-463f-aa9a-b00f264385f6" name="Outputs" type="Block">
<subsheetid>bad96847-65f0-40bc-be35-8d593764ca18</subsheetid>
<loginhibit />
<font family="Segoe UI" size="10" style="Regular" color="00FF00" />
<displayx>-255</displayx>
<displayy>-45</displayy>
<displaywidth>120</displaywidth>
<displayheight>105</displayheight>
</stage>
<stage stageid="1e8cb84b-1ac1-4b3d-9fde-03b3d0589f28" name="Local Data Items" type="Block">
<subsheetid>a487438c-3391-4a66-a1a6-5f40ebc64115</subsheetid>
<loginhibit />
<font family="Segoe UI" size="10" style="Regular" color="FFCC00" />
<displayx>-270</displayx>
<displayy>45</displayy>
<displaywidth>150</displaywidth>
<displayheight>60</displayheight>
</stage>
<stage stageid="7024514f-8d39-4f3d-80a5-f37bf3417441" name="Outputs" type="Block">
<subsheetid>a487438c-3391-4a66-a1a6-5f40ebc64115</subsheetid>
<loginhibit />
<font family="Segoe UI" size="10" style="Regular" color="00FF00" />
<displayx>-270</displayx>
<displayy>-45</displayy>
<displaywidth>150</displaywidth>
<displayheight>75</displayheight>
</stage>
<stage stageid="0f08233a-4b76-4239-8463-405e75141a85" name="Local Data Items" type="Block">
<subsheetid>fe9fac62-8a9a-4b7d-846c-418f73082557</subsheetid>
<loginhibit />
<font family="Segoe UI" size="10" style="Regular" color="FFCC00" />
<displayx>-270</displayx>
<displayy>75</displayy>
<displaywidth>150</displaywidth>
<displayheight>75</displayheight>
</stage>
<stage stageid="8867c788-0ecd-4299-bd56-88600f35d7f3" name="Outputs" type="Block">
<subsheetid>fe9fac62-8a9a-4b7d-846c-418f73082557</subsheetid>
<loginhibit />
<font family="Segoe UI" size="10" style="Regular" color="00FF00" />
<displayx>-270</displayx>
<displayy>-45</displayy>
<displaywidth>150</displaywidth>
<displayheight>105</displayheight>
</stage>
<stage stageid="2fd878a1-f4a3-4aef-b6a3-de2133522fd8" name="Local Data Items" type="Block">
<subsheetid>540e741c-c8b3-4b39-9574-4abc24bd8bc9</subsheetid>
<loginhibit />
<font family="Segoe UI" size="10" style="Regular" color="FFCC00" />
<displayx>-270</displayx>
<displayy>135</displayy>
<displaywidth>180</displaywidth>
<displayheight>60</displayheight>
</stage>
<stage stageid="72b0911a-10d6-4330-868a-555acf6ffd44" name="Outputs" type="Block">
<subsheetid>540e741c-c8b3-4b39-9574-4abc24bd8bc9</subsheetid>
<loginhibit />
<font family="Segoe UI" size="10" style="Regular" color="00FF00" />
<displayx>-270</displayx>
<displayy>15</displayy>
<displaywidth>150</displaywidth>
<displayheight>105</displayheight>
</stage>
<stage stageid="ac615999-597b-45cc-b9b0-ef4b3503da33" name="Inputs" type="Block">
<subsheetid>540e741c-c8b3-4b39-9574-4abc24bd8bc9</subsheetid>
<loginhibit />
<font family="Segoe UI" size="10" style="Regular" color="FFFF00" />
<displayx>-270</displayx>
<displayy>-60</displayy>
<displaywidth>150</displaywidth>
<displayheight>60</displayheight>
</stage>
<stage stageid="c825dc6b-9141-4036-ac6f-20c5bb15f8c8" name="Local Data Items" type="Block">
<subsheetid>032119f9-342d-4b7e-ab12-c018b781a2f3</subsheetid>
<loginhibit />
<font family="Segoe UI" size="10" style="Regular" color="FFCC00" />
<displayx>-270</displayx>
<displayy>195</displayy>
<displaywidth>150</displaywidth>
<displayheight>105</displayheight>
</stage>
<stage stageid="6de9b7f0-aeaa-4aff-8c40-1eebaa95555f" name="Outputs" type="Block">
<subsheetid>032119f9-342d-4b7e-ab12-c018b781a2f3</subsheetid>
<loginhibit />
<font family="Segoe UI" size="10" style="Regular" color="00FF00" />
<displayx>-270</displayx>
<displayy>30</displayy>
<displaywidth>150</displaywidth>
<displayheight>150</displayheight>
</stage>
<stage stageid="c234f439-326d-4d70-95d0-c05f7b23cdd3" name="Inputs" type="Block">
<subsheetid>032119f9-342d-4b7e-ab12-c018b781a2f3</subsheetid>
<loginhibit />
<font family="Segoe UI" size="10" style="Regular" color="FFFF00" />
<displayx>-270</displayx>
<displayy>-45</displayy>
<displaywidth>150</displaywidth>
<displayheight>60</displayheight>
</stage>
<stage stageid="6456da84-9a2f-451b-b211-18a957e074b7" name="Local Data Items" type="Block">
<subsheetid>48d79c6a-7dc2-4a23-a601-7421f7fb5280</subsheetid>
<loginhibit />
<font family="Segoe UI" size="10" style="Regular" color="FFCC00" />
<displayx>-270</displayx>
<displayy>195</displayy>
<displaywidth>150</displaywidth>
<displayheight>105</displayheight>
</stage>
<stage stageid="21d5daf9-94ee-4f6e-8d6f-d9c0938ffad3" name="Outputs" type="Block">
<subsheetid>48d79c6a-7dc2-4a23-a601-7421f7fb5280</subsheetid>
<loginhibit />
<font family="Segoe UI" size="10" style="Regular" color="00FF00" />
<displayx>-270</displayx>
<displayy>30</displayy>
<displaywidth>150</displaywidth>
<displayheight>150</displayheight>
</stage>
<stage stageid="2506ae4c-cf9e-4b79-8f50-32b976d98132" name="Inputs" type="Block">
<subsheetid>48d79c6a-7dc2-4a23-a601-7421f7fb5280</subsheetid>
<loginhibit />
<font family="Segoe UI" size="10" style="Regular" color="FFFF00" />
<displayx>-270</displayx>
<displayy>-45</displayy>
<displaywidth>150</displaywidth>
<displayheight>60</displayheight>
</stage>
<stage stageid="d1e7b669-20a4-4a94-aad2-3f0294ca66b7" name="Local Data Items" type="Block">
<subsheetid>a05c17eb-69e9-4f1e-b50c-cc1c353eef22</subsheetid>
<loginhibit />
<font family="Segoe UI" size="10" style="Regular" color="FFCC00" />
<displayx>-270</displayx>
<displayy>195</displayy>
<displaywidth>150</displaywidth>
<displayheight>105</displayheight>
</stage>
<stage stageid="6bbcfb4a-699f-4422-a572-5fca03128119" name="Outputs" type="Block">
<subsheetid>a05c17eb-69e9-4f1e-b50c-cc1c353eef22</subsheetid>
<loginhibit />
<font family="Segoe UI" size="10" style="Regular" color="00FF00" />
<displayx>-270</displayx>
<displayy>30</displayy>
<displaywidth>150</displaywidth>
<displayheight>150</displayheight>
</stage>
<stage stageid="a6a85db4-260d-4a09-9e43-49f7452830c4" name="Inputs" type="Block">
<subsheetid>a05c17eb-69e9-4f1e-b50c-cc1c353eef22</subsheetid>
<loginhibit />
<font family="Segoe UI" size="10" style="Regular" color="FFFF00" />
<displayx>-270</displayx>
<displayy>-45</displayy>
<displaywidth>150</displaywidth>
<displayheight>60</displayheight>
</stage>
<stage stageid="a1dd804f-356b-45da-b145-e98a51fedb6b" name="Local Data Items" type="Block">
<subsheetid>d2d014d5-71ff-47d1-8a2d-adf47aa96ab6</subsheetid>
<loginhibit />
<font family="Segoe UI" size="10" style="Regular" color="FFCC00" />
<displayx>-270</displayx>
<displayy>195</displayy>
<displaywidth>150</displaywidth>
<displayheight>105</displayheight>
</stage>
<stage stageid="148e3394-7890-4499-9e99-a4884adf5986" name="Outputs" type="Block">
<subsheetid>d2d014d5-71ff-47d1-8a2d-adf47aa96ab6</subsheetid>
<loginhibit />
<font family="Segoe UI" size="10" style="Regular" color="00FF00" />
<displayx>-270</displayx>
<displayy>30</displayy>
<displaywidth>150</displaywidth>
<displayheight>150</displayheight>
</stage>
<stage stageid="575c712e-303b-423c-b0e8-d4a9869e228a" name="Inputs" type="Block">
<subsheetid>d2d014d5-71ff-47d1-8a2d-adf47aa96ab6</subsheetid>
<loginhibit />
<font family="Segoe UI" size="10" style="Regular" color="FFFF00" />
<displayx>-270</displayx>
<displayy>-45</displayy>
<displaywidth>150</displaywidth>
<displayheight>60</displayheight>
</stage>
<stage stageid="e351253a-12a4-4e21-9d5e-484ff74d3261" name="Outputs" type="Block">
<subsheetid>379163bf-d2ab-47d2-9132-1827ccf80e66</subsheetid>
<loginhibit />
<font family="Segoe UI" size="10" style="Regular" color="00FF00" />
<displayx>-270</displayx>
<displayy>75</displayy>
<displaywidth>150</displaywidth>
<displayheight>135</displayheight>
</stage>
<stage stageid="031fe65d-ff87-4d9c-a2af-1f6460890048" name="Inputs" type="Block">
<subsheetid>379163bf-d2ab-47d2-9132-1827ccf80e66</subsheetid>
<loginhibit />
<font family="Segoe UI" size="10" style="Regular" color="FFFF00" />
<displayx>-270</displayx>
<displayy>-45</displayy>
<displaywidth>150</displaywidth>
<displayheight>105</displayheight>
</stage>
<stage stageid="733bf48e-7764-4a44-a6b5-d5da3635617a" name="Outputs" type="Block">
<subsheetid>15d519d8-1803-4720-821c-3ccea40d8273</subsheetid>
<loginhibit />
<font family="Segoe UI" size="10" style="Regular" color="00FF00" />
<displayx>-270</displayx>
<displayy>75</displayy>
<displaywidth>150</displaywidth>
<displayheight>105</displayheight>
</stage>
<stage stageid="b4fd6ea1-43d2-4ac7-98a7-d52cf63427dd" name="Inputs" type="Block">
<subsheetid>15d519d8-1803-4720-821c-3ccea40d8273</subsheetid>
<loginhibit />
<font family="Segoe UI" size="10" style="Regular" color="FFFF00" />
<displayx>-270</displayx>
<displayy>-45</displayy>
<displaywidth>150</displaywidth>
<displayheight>105</displayheight>
</stage>
<stage stageid="9206aaf2-9062-4062-aa90-a6f8d9d46e5c" name="Outputs" type="Block">
<subsheetid>ba1c8e81-ef16-4940-a993-09fe604cda76</subsheetid>
<loginhibit />
<font family="Segoe UI" size="10" style="Regular" color="00FF00" />
<displayx>-270</displayx>
<displayy>30</displayy>
<displaywidth>150</displaywidth>
<displayheight>105</displayheight>
</stage>
<stage stageid="14fcfaa5-7243-4687-983f-0cc37bc635b2" name="Inputs" type="Block">
<subsheetid>ba1c8e81-ef16-4940-a993-09fe604cda76</subsheetid>
<loginhibit />
<font family="Segoe UI" size="10" style="Regular" color="FFFF00" />
<displayx>-270</displayx>
<displayy>-45</displayy>
<displaywidth>150</displaywidth>
<displayheight>60</displayheight>
</stage>
<stage stageid="9e68eb8f-d687-405f-97bb-42a311868e9f" name="Outputs" type="Block">
<subsheetid>43d80e10-0a8d-46f4-abcb-19fcbd68fc6b</subsheetid>
<loginhibit />
<font family="Segoe UI" size="10" style="Regular" color="00FF00" />
<displayx>-270</displayx>
<displayy>-45</displayy>
<displaywidth>150</displaywidth>
<displayheight>90</displayheight>
</stage>
<stage stageid="e38d5c79-90ad-43a5-8fde-446e4cd9d054" name="Outputs" type="Block">
<subsheetid>5c204a77-ccc6-45cd-a3be-936abb251c49</subsheetid>
<loginhibit />
<font family="Segoe UI" size="10" style="Regular" color="00FF00" />
<displayx>-270</displayx>
<displayy>-45</displayy>
<displaywidth>150</displaywidth>
<displayheight>90</displayheight>
</stage>
</process>
</object>
<environment-variable id="Blue Prism - OracleMDA_Host" name="Blue Prism - OracleMDA_Host" type="text" value="" xmlns="http://www.blueprism.co.uk/product/environment-variable">
<description />
</environment-variable>
<environment-variable id="Blue Prism - OracleMDA_Password" name="Blue Prism - OracleMDA_Password" type="password" value="aCpGKl8qTyp6KlgqQypZKkcqBCppKkUqRypHKkUqRCoEKnkqTypJKl8qWCpDKl4qUyoEKnkqQypHKloqRipPKmUqSCpMKl8qWSpJKksqXipFKlgq:" xmlns="http://www.blueprism.co.uk/product/environment-variable">
<description />
</environment-variable>
<environment-variable id="Blue Prism - OracleMDA_Port" name="Blue Prism - OracleMDA_Port" type="text" value="" xmlns="http://www.blueprism.co.uk/product/environment-variable">
<description />
</environment-variable>
<environment-variable id="Blue Prism - OracleMDA_SID" name="Blue Prism - OracleMDA_SID" type="text" value="" xmlns="http://www.blueprism.co.uk/product/environment-variable">
<description />
</environment-variable>
<environment-variable id="Blue Prism - OracleMDA_User" name="Blue Prism - OracleMDA_User" type="text" value="" xmlns="http://www.blueprism.co.uk/product/environment-variable">
<description />
</environment-variable>
<process-group id="ff1d8e3b-5812-4c4c-a9f8-a1a8192fc815" name="Default" isDefaultGroup="True" xmlns="http://www.blueprism.co.uk/product/process-group">
<members>
<process id="a900623b-8d3d-4dbe-9183-61ad2a919fdc" />
</members>
</process-group>
<object-group id="245c1937-f009-4f74-83bc-696909e45db1" name="Default" isDefaultGroup="True" xmlns="http://www.blueprism.co.uk/product/object-group">
<members>
<object id="8681616d-c07d-4948-894a-36865708e237" />
</members>
</object-group>
</bpr:contents>
</bpr:release>
You can’t perform that action at this time.