OracleMDA_4
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.
2021-01-04 12:42:05Z
20
Blue Prism - Oracle MDA
admin
-203
124
1.25
DROP TABLE
-8
0
1.25
DELETE ROWS
-8
0
1.25
TRUNCATE TABLE
-8
0
1.25
Get Machine Name
0
0
1.25
Get User Name
0
0
1.25
Get CSV
-63
0
1.25
Get CSV File
0
0
1.25
Transaction - Commit
-38
-1
1.25
Get Collection
0
0
1.25
8269a258-d7bb-4a6b-8557-b01c76fec6cf
15
-150
15
120
-195
-105
150
90
text
Environment
-195
-15
180
30
text
Environment
-195
30
180
30
text
Environment
-195
75
180
30
text
Environment
-195
120
180
30
password
Environment
-195
165
180
30
text
-195
210
40b71b60-2c56-4235-9d5d-482a0f568d00
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.
-195
-105
150
90
40b71b60-2c56-4235-9d5d-482a0f568d00
79bec70c-b644-4c06-accb-dd06db46fb3c
15
-105
40b71b60-2c56-4235-9d5d-482a0f568d00
15
90
40b71b60-2c56-4235-9d5d-482a0f568d00
92a5a17e-886b-456b-a086-dd8cd6317b68
15
15
40b71b60-2c56-4235-9d5d-482a0f568d00
flag
-135
120
40b71b60-2c56-4235-9d5d-482a0f568d00
text
-210
120
90
30
40b71b60-2c56-4235-9d5d-482a0f568d00
d1b1cbd3-b664-4a44-9278-eafa441ebbd1
15
-45
120
30
40b71b60-2c56-4235-9d5d-482a0f568d00
text
-180
-15
90
30
40b71b60-2c56-4235-9d5d-482a0f568d00
flag
False
-180
30
120
30
e72a8467-73cd-4ae4-9eba-a8950f47f49f
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.
-195
-105
270
90
e72a8467-73cd-4ae4-9eba-a8950f47f49f
735ec94e-5ceb-4c8b-989a-d64229b22ddf
30
-90
e72a8467-73cd-4ae4-9eba-a8950f47f49f
30
105
e72a8467-73cd-4ae4-9eba-a8950f47f49f
a955c6ad-3d3a-495f-8d3c-c8ad981f54bb
30
30
120
30
e72a8467-73cd-4ae4-9eba-a8950f47f49f
flag
-180
105
e72a8467-73cd-4ae4-9eba-a8950f47f49f
text
-255
105
90
30
e72a8467-73cd-4ae4-9eba-a8950f47f49f
53afebf6-06fd-4f53-a6d5-03d95e3d18e7
30
-30
120
30
e72a8467-73cd-4ae4-9eba-a8950f47f49f
text
-240
-15
120
30
e72a8467-73cd-4ae4-9eba-a8950f47f49f
flag
False
-135
-15
120
30
e72a8467-73cd-4ae4-9eba-a8950f47f49f
text
ID=6
-255
30
90
30
607b66af-d5eb-4234-850f-6dc9ded407c3
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.
-195
-105
180
90
607b66af-d5eb-4234-850f-6dc9ded407c3
f870a29e-1196-4351-8e90-30e601ca99d1
30
-90
607b66af-d5eb-4234-850f-6dc9ded407c3
30
105
607b66af-d5eb-4234-850f-6dc9ded407c3
8ce78476-df62-4705-867b-1a2f68b1e381
30
30
120
30
607b66af-d5eb-4234-850f-6dc9ded407c3
flag
-150
105
607b66af-d5eb-4234-850f-6dc9ded407c3
text
-225
105
90
30
607b66af-d5eb-4234-850f-6dc9ded407c3
fe318cbd-b6c5-4607-adb3-6c126fbce5a4
30
-30
120
30
607b66af-d5eb-4234-850f-6dc9ded407c3
text
-195
-15
120
30
607b66af-d5eb-4234-850f-6dc9ded407c3
flag
False
-195
30
120
30
1a7f8351-c5c0-4486-b1be-7edaa9b3b888
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.
-195
-105
150
90
1a7f8351-c5c0-4486-b1be-7edaa9b3b888
fa881d9a-0b9a-4611-a32b-d0bbf99d7fc0
15
-105
1a7f8351-c5c0-4486-b1be-7edaa9b3b888
15
90
1a7f8351-c5c0-4486-b1be-7edaa9b3b888
5415a1a6-7613-42c6-ae66-2a70f4249808
15
-15
120
30
1a7f8351-c5c0-4486-b1be-7edaa9b3b888
text
-195
0
120
30
fbee9ab3-c882-4b15-93b3-7b51b3b60772
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.
-195
-105
150
90
fbee9ab3-c882-4b15-93b3-7b51b3b60772
e064082c-07c0-4aaa-a1ee-4cf8470a101e
15
-105
fbee9ab3-c882-4b15-93b3-7b51b3b60772
15
90
fbee9ab3-c882-4b15-93b3-7b51b3b60772
74a06db3-6852-4325-b7c2-b7caaff81fff
15
-15
fbee9ab3-c882-4b15-93b3-7b51b3b60772
text
-195
15
120
30
e51225a7-9878-4669-aa28-7b96c3892373
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.
-180
-105
180
90
e51225a7-9878-4669-aa28-7b96c3892373
d070b74b-e597-45be-8270-4ee57e663f84
15
-105
e51225a7-9878-4669-aa28-7b96c3892373
15
90
e51225a7-9878-4669-aa28-7b96c3892373
8fee0e82-5df9-42db-bbc2-4fe736d61c12
15
-15
e51225a7-9878-4669-aa28-7b96c3892373
text
Select * from [Table]
-180
-15
150
30
e51225a7-9878-4669-aa28-7b96c3892373
text
-180
105
150
30
e51225a7-9878-4669-aa28-7b96c3892373
text
-135
60
e51225a7-9878-4669-aa28-7b96c3892373
flag
-225
60
1d6d6457-faf8-4638-8009-7e1399aa73b0
-180
-105
180
90
1d6d6457-faf8-4638-8009-7e1399aa73b0
0cc3926b-00e6-4e02-8286-1bad4a33e0b1
15
-105
1d6d6457-faf8-4638-8009-7e1399aa73b0
15
90
1d6d6457-faf8-4638-8009-7e1399aa73b0
a6629b97-52aa-4ae8-aeed-c6e576a13bf2
15
15
90
30
1d6d6457-faf8-4638-8009-7e1399aa73b0
text
Select * from [Table]
-180
-15
120
30
1d6d6457-faf8-4638-8009-7e1399aa73b0
text
E:\OracleData.CSV
-180
30
150
30
1d6d6457-faf8-4638-8009-7e1399aa73b0
flag
-225
105
1d6d6457-faf8-4638-8009-7e1399aa73b0
text
-135
105
b7fd8cc2-f883-437e-8560-fb8d0c6c2c66
This is a sample of a full transaction, showing begin and commit.
-195
-120
150
90
b7fd8cc2-f883-437e-8560-fb8d0c6c2c66
c701c7d4-d738-47cf-8713-fdaf16164821
15
-150
b7fd8cc2-f883-437e-8560-fb8d0c6c2c66
15
150
b7fd8cc2-f883-437e-8560-fb8d0c6c2c66
f58358e7-6d23-4fd8-b7eb-79d7d2717a0e
15
-90
b7fd8cc2-f883-437e-8560-fb8d0c6c2c66
flag
-255
120
b7fd8cc2-f883-437e-8560-fb8d0c6c2c66
text
-150
120
90
30
b7fd8cc2-f883-437e-8560-fb8d0c6c2c66
de1e3a81-8c38-415e-922e-739e7b9d306b
15
-30
b7fd8cc2-f883-437e-8560-fb8d0c6c2c66
text
INSERT INTO [Table]
Values ([v1,v2,v3)
-195
-15
180
30
b7fd8cc2-f883-437e-8560-fb8d0c6c2c66
d9bd80f8-f376-42ec-886b-728db0d91558
15
30
b7fd8cc2-f883-437e-8560-fb8d0c6c2c66
text
Select * from [Table] where ID=[Value]
-195
45
210
30
b7fd8cc2-f883-437e-8560-fb8d0c6c2c66
89ee9714-effc-4bec-8ac2-e2b1128517d0
15
90
00bad46a-aff4-4971-970b-01b796172688
This function takes in a valid SQL Select script and returns the results in a Blue Prism Collection.
-195
-105
150
90
00bad46a-aff4-4971-970b-01b796172688
1ad1e55b-1cac-4f52-b0ce-d64fd6b795b8
15
-105
00bad46a-aff4-4971-970b-01b796172688
15
90
00bad46a-aff4-4971-970b-01b796172688
9ebce978-91ff-4b1c-a737-bb52d318ed16
15
15
90
30
00bad46a-aff4-4971-970b-01b796172688
text
Select * from [Table]
-195
-15
00bad46a-aff4-4971-970b-01b796172688
flag
-165
75
00bad46a-aff4-4971-970b-01b796172688
text
-225
75
00bad46a-aff4-4971-970b-01b796172688
collection
-195
120
00bad46a-aff4-4971-970b-01b796172688
5d11970d-867e-439a-be3b-42b14d03e4ef
15
-45
90
30
b7fd8cc2-f883-437e-8560-fb8d0c6c2c66
number
-195
165
120
30
40b71b60-2c56-4235-9d5d-482a0f568d00
-270
-45
180
120
40b71b60-2c56-4235-9d5d-482a0f568d00
-270
90
180
60
e72a8467-73cd-4ae4-9eba-a8950f47f49f
-315
75
180
60
e72a8467-73cd-4ae4-9eba-a8950f47f49f
-315
-45
255
105
607b66af-d5eb-4234-850f-6dc9ded407c3
-285
75
180
60
607b66af-d5eb-4234-850f-6dc9ded407c3
-285
-45
180
105
e51225a7-9878-4669-aa28-7b96c3892373
-270
30
180
105
e51225a7-9878-4669-aa28-7b96c3892373
-270
-45
180
60
1d6d6457-faf8-4638-8009-7e1399aa73b0
-270
75
180
60
1d6d6457-faf8-4638-8009-7e1399aa73b0
-270
-45
180
105
b7fd8cc2-f883-437e-8560-fb8d0c6c2c66
-300
-45
210
120
b7fd8cc2-f883-437e-8560-fb8d0c6c2c66
-300
90
210
105
1a7f8351-c5c0-4486-b1be-7edaa9b3b888
-270
-30
150
60
fbee9ab3-c882-4b15-93b3-7b51b3b60772
-270
-15
150
60
00bad46a-aff4-4971-970b-01b796172688
-270
45
150
105
00bad46a-aff4-4971-970b-01b796172688
-270
-45
150
60
-300
-45
210
285
b51d847c-a253-4723-b8b2-9791ac429d78
Application
Application
unknown
False
64
39
1.25
Clean Up
0
0
1.25
Configure
0
-30
1.25
Raise Exception If Appropriate
-102
3
1.25
Set Connection
0
21
1.25
Open
-56
0
1.25
Close
0
0
1.25
Is Open
-41
0
1.25
Internal Close
-1
15
1.25
Begin Transaction
-20
45
1.25
Commit Transaction
0
42
1.25
Rollback Transaction
0
21
1.25
Execute
-53
37
1.25
Get Number
-112
10
1.25
Get Text
-225
-21
1.25
Get Collection
-188
42
1.25
Get CSV File
-3
61
1.25
Get CSV
-65
42
1.25
Get User Name
0
0
1.25
Get Machine Name
-103
0
1.25
Delete Rows - Where
0
21
1.25
Drop Table
7
10
1.25
Truncate Table
7
-11
1.25
3706037c-9ce5-4836-a0bd-3201c0f182b0
15
-105
15
90
System.dll
System.Data.dll
System.Xml.dll
System.Drawing.dll
Oracle.ManagedDataAccess.dll
System
System.Drawing
System.Data
Oracle.ManagedDataAccess.Client
System.IO
csharp
= 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(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);
}
}
]]>
-195
-105
150
90
72c790c5-372a-4eb5-804b-5ee825cbdf29
-195
-105
150
90
72c790c5-372a-4eb5-804b-5ee825cbdf29
95418068-629d-482e-b6de-2d0700d64324
15
-105
72c790c5-372a-4eb5-804b-5ee825cbdf29
15
90
ccacb83a-6ee1-4fc5-9c2b-d09215a4f561
Configures this instance of the utility VBO. Calling it with no parameters will cause the configuration to be reset to default values.
-195
-105
150
90
ccacb83a-6ee1-4fc5-9c2b-d09215a4f561
d3a89de2-7d36-4999-97ce-db033ac7f336
15
-105
ccacb83a-6ee1-4fc5-9c2b-d09215a4f561
15
15
72c790c5-372a-4eb5-804b-5ee825cbdf29
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.
-180
60
180
230
ccacb83a-6ee1-4fc5-9c2b-d09215a4f561
flag
False
-195
-15
180
30
88b62fd7-41a8-4bc7-806a-bd8e1b5497ca
Debugging Tool. Set this variable to true to expose exceptions.
-195
-105
150
60
88b62fd7-41a8-4bc7-806a-bd8e1b5497ca
93c91ad7-3d15-4d03-bd8b-c883b774d565
15
-105
88b62fd7-41a8-4bc7-806a-bd8e1b5497ca
15
30
88b62fd7-41a8-4bc7-806a-bd8e1b5497ca
flag
-225
15
88b62fd7-41a8-4bc7-806a-bd8e1b5497ca
text
-165
15
88b62fd7-41a8-4bc7-806a-bd8e1b5497ca
27775845-b030-4aa2-b505-f7eff110fda6
f37cdc05-bffc-4cd7-bb4a-44256b547d97
15
-45
90
60
88b62fd7-41a8-4bc7-806a-bd8e1b5497ca
120
-45
241b279e-d44c-422b-9421-669b95323468
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.
-195
-105
150
90
241b279e-d44c-422b-9421-669b95323468
23379fc1-8199-40a0-b60c-a144ffe2411d
15
-105
241b279e-d44c-422b-9421-669b95323468
15
195
241b279e-d44c-422b-9421-669b95323468
flag
-195
-15
90
30
241b279e-d44c-422b-9421-669b95323468
text
-195
15
90
30
The connection name as used in SQL Developer.
text
180
-165
180
30
The IP address of the computer that is hosting the Oracle RDBMS
text
180
-120
180
30
text
180
-75
180
30
password
180
30
180
30
text
180
75
180
30
number
0
180
135
180
30
flag
False
180
180
180
30
Flag indicating that the connection wrapped by this VBO is currently in the process of closing
flag
False
180
225
180
30
241b279e-d44c-422b-9421-669b95323468
c7de8c51-e623-4f7d-abc0-5ae060147a49
8cc10863-aadb-43f0-a893-ab9f338af9eb
15
-45
120
30
241b279e-d44c-422b-9421-669b95323468
a3642585-8c94-47f7-9057-3080785bf368
e0942963-e085-4d12-851e-f1909dec741e
15
60
241b279e-d44c-422b-9421-669b95323468
6411380e-6a99-446f-9285-2a0143854c4f
15
15
10
10
241b279e-d44c-422b-9421-669b95323468
dfa48d56-299e-404b-882a-c924299e9968
-45
60
10
10
241b279e-d44c-422b-9421-669b95323468
d4784445-e461-42b9-8324-8e6cebd6fac9
75
60
10
10
241b279e-d44c-422b-9421-669b95323468
1054a4ca-66c5-4bbd-b2c7-6c2db1803206
-45
105
241b279e-d44c-422b-9421-669b95323468
30c57d5f-e547-4f10-8b4f-c721a474027a
75
105
241b279e-d44c-422b-9421-669b95323468
63eec0fc-57a8-443e-88e3-353595c7ab73
-45
195
10
10
241b279e-d44c-422b-9421-669b95323468
63eec0fc-57a8-443e-88e3-353595c7ab73
75
195
10
10
f64b457a-dfb7-4200-9a9f-5dd147561478
This is an internally used class for opening the connection. It is not published for use in processes.
-195
-105
150
90
f64b457a-dfb7-4200-9a9f-5dd147561478
3267a4fd-49b5-4073-991d-54c06427cefa
15
-135
f64b457a-dfb7-4200-9a9f-5dd147561478
15
285
241b279e-d44c-422b-9421-669b95323468
8cc10863-aadb-43f0-a893-ab9f338af9eb
f64b457a-dfb7-4200-9a9f-5dd147561478
165
15
f64b457a-dfb7-4200-9a9f-5dd147561478
836602a9-c431-4003-9114-b1781b79f736
2b679340-4669-481d-a262-513ad5503884
15
-75
f64b457a-dfb7-4200-9a9f-5dd147561478
bdb2e204-909b-4eec-a5b3-d7e001bce6ef
15
-15
90
30
f64b457a-dfb7-4200-9a9f-5dd147561478
3f13478d-668e-4544-9cfd-1a33770ee2f1
e4b79dd3-f709-42da-a7b1-70d9fd212f98
15
45
f64b457a-dfb7-4200-9a9f-5dd147561478
flag
False
-195
-15
90
30
f64b457a-dfb7-4200-9a9f-5dd147561478
text
-195
30
90
30
f64b457a-dfb7-4200-9a9f-5dd147561478
flag
True
-195
105
90
30
fe9fac62-8a9a-4b7d-846c-418f73082557
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.
-195
-105
150
90
fe9fac62-8a9a-4b7d-846c-418f73082557
d14fe624-99d5-400b-b824-5dabd803c1d5
15
-180
fe9fac62-8a9a-4b7d-846c-418f73082557
15
180
f64b457a-dfb7-4200-9a9f-5dd147561478
2c124765-5fe1-4dd4-931e-3c35177b8fc0
fe9fac62-8a9a-4b7d-846c-418f73082557
15
105
f64b457a-dfb7-4200-9a9f-5dd147561478
-30
75
180
60
f64b457a-dfb7-4200-9a9f-5dd147561478
f2f31bb0-4ee8-418b-8b8f-5425de848229
105
105
f64b457a-dfb7-4200-9a9f-5dd147561478
2c124765-5fe1-4dd4-931e-3c35177b8fc0
105
165
f64b457a-dfb7-4200-9a9f-5dd147561478
3f894655-dcd0-4539-945b-52878a424515
15
165
f64b457a-dfb7-4200-9a9f-5dd147561478
300588fc-175b-4f38-bb7f-6045a221374a
15
225
f64b457a-dfb7-4200-9a9f-5dd147561478
7a4679e9-e0aa-4de6-b118-453f9472fd05
-45
45
10
10
f64b457a-dfb7-4200-9a9f-5dd147561478
2c124765-5fe1-4dd4-931e-3c35177b8fc0
-45
165
10
10
f64b457a-dfb7-4200-9a9f-5dd147561478
Ensure that we're not being called by 'Rollback' which was called by this action - infinite loops are bad.
ac9693d7-26c8-438f-be10-5c79eeb4d641
165
-75
150
60
f64b457a-dfb7-4200-9a9f-5dd147561478
300588fc-175b-4f38-bb7f-6045a221374a
165
285
10
10
f64b457a-dfb7-4200-9a9f-5dd147561478
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.
-165
270
270
60
fe9fac62-8a9a-4b7d-846c-418f73082557
73031632-58af-4fe7-9bfc-a12ba15e4f64
d40038be-a67f-44ef-82ab-a69517948586
15
-120
fe9fac62-8a9a-4b7d-846c-418f73082557
bdb1c15d-229b-49f2-8842-7a8979400deb
-75
-120
fe9fac62-8a9a-4b7d-846c-418f73082557
6acea178-83ac-4b1d-8416-93b4448ac02f
15
-60
120
30
fe9fac62-8a9a-4b7d-846c-418f73082557
flag
False
-195
-15
90
30
fe9fac62-8a9a-4b7d-846c-418f73082557
text
-195
30
90
30
fe9fac62-8a9a-4b7d-846c-418f73082557
flag
-225
120
fe9fac62-8a9a-4b7d-846c-418f73082557
text
-165
120
fe9fac62-8a9a-4b7d-846c-418f73082557
a3561b5a-70ba-4972-8d75-8ec7870355d7
15
0
fe9fac62-8a9a-4b7d-846c-418f73082557
29e41eea-0feb-4bd6-8454-64ef8c97bfb2
f64b457a-dfb7-4200-9a9f-5dd147561478
15
60
fe9fac62-8a9a-4b7d-846c-418f73082557
0982e856-5781-4c2b-8a93-6e1730a9e303
88b62fd7-41a8-4bc7-806a-bd8e1b5497ca
15
120
fe9fac62-8a9a-4b7d-846c-418f73082557
a3561b5a-70ba-4972-8d75-8ec7870355d7
-75
60
10
10
d7f92fab-b3c7-4c06-ae2d-503e20b73fd7
This is an internally used class for opening the connection. It is not published for use in processes.
-195
-105
150
90
d7f92fab-b3c7-4c06-ae2d-503e20b73fd7
00698ea1-1f54-4ff3-b569-095808fbd9b0
15
-105
d7f92fab-b3c7-4c06-ae2d-503e20b73fd7
15
135
d7f92fab-b3c7-4c06-ae2d-503e20b73fd7
flag
False
-195
-15
90
30
d7f92fab-b3c7-4c06-ae2d-503e20b73fd7
text
-195
30
90
30
d7f92fab-b3c7-4c06-ae2d-503e20b73fd7
b69b3d4c-31fa-4200-bc51-6ba91231f505
15
15
d7f92fab-b3c7-4c06-ae2d-503e20b73fd7
b6156a37-fe0b-4731-b6b2-acc5c38f55b6
88b62fd7-41a8-4bc7-806a-bd8e1b5497ca
15
75
text
180
-30
180
30
241b279e-d44c-422b-9421-669b95323468
Close and clear the connection pool
abd3ec34-0739-4a78-816c-a307bb7f7719
165
-45
120
30
3a8c9643-d2ff-4ff3-a035-cde16e518ba8
This is an internally used class for opening the connection. It is not published for use in processes.
-195
-105
150
90
3a8c9643-d2ff-4ff3-a035-cde16e518ba8
0c0a96fe-7d9a-4fb6-b233-bb9d5fa7db9b
15
-105
3a8c9643-d2ff-4ff3-a035-cde16e518ba8
15
15
3a8c9643-d2ff-4ff3-a035-cde16e518ba8
flag
-195
-30
3a8c9643-d2ff-4ff3-a035-cde16e518ba8
text
-195
15
3a8c9643-d2ff-4ff3-a035-cde16e518ba8
5a003f93-de9d-45b7-b880-bebc46f8038d
f64b457a-dfb7-4200-9a9f-5dd147561478
15
-45
ea43971d-49fa-4f4e-9f46-9fc8bc6135b0
This is an internally used class for opening the connection. It is not published for use in processes.
-195
-105
150
90
ea43971d-49fa-4f4e-9f46-9fc8bc6135b0
ff3c60b2-4193-4c8a-9df9-8676a2696d88
15
-105
ea43971d-49fa-4f4e-9f46-9fc8bc6135b0
15
15
ea43971d-49fa-4f4e-9f46-9fc8bc6135b0
fd0e19e1-c17f-41e2-a4b7-16e8dd1846eb
15
-45
ea43971d-49fa-4f4e-9f46-9fc8bc6135b0
flag
-195
-30
90
30
bad96847-65f0-40bc-be35-8d593764ca18
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.
-195
-105
150
90
bad96847-65f0-40bc-be35-8d593764ca18
305c4740-3ce8-42c9-87cb-c9177fcf7940
15
-225
bad96847-65f0-40bc-be35-8d593764ca18
15
315
bad96847-65f0-40bc-be35-8d593764ca18
flag
False
-195
-15
90
30
bad96847-65f0-40bc-be35-8d593764ca18
text
-195
30
90
30
bad96847-65f0-40bc-be35-8d593764ca18
flag
-195
105
bad96847-65f0-40bc-be35-8d593764ca18
a159b46d-3123-4ab7-b57a-a87e74ffc73d
1daa6365-d77c-4c76-93cc-0c6698c2cde9
15
-165
90
30
bad96847-65f0-40bc-be35-8d593764ca18
28a2d368-2750-4464-b15a-8d26593fdc2c
240
-165
120
30
bad96847-65f0-40bc-be35-8d593764ca18
9002fe90-08b3-46d5-b275-a43285a0f98c
ea43971d-49fa-4f4e-9f46-9fc8bc6135b0
15
-105
bad96847-65f0-40bc-be35-8d593764ca18
b6946861-0c2f-4137-abc8-10fe43c66e24
58180489-d7c1-4201-bd7d-809850465982
15
-45
bad96847-65f0-40bc-be35-8d593764ca18
d2a69cd8-bcd7-4cd1-8c3f-4184ffbc973e
d7f92fab-b3c7-4c06-ae2d-503e20b73fd7
15
15
bad96847-65f0-40bc-be35-8d593764ca18
f2f27764-a922-4a6d-92a7-f72eab3e84b4
15
105
bad96847-65f0-40bc-be35-8d593764ca18
65855cce-e52f-4d97-a96b-012e5349557c
28a2d368-2750-4464-b15a-8d26593fdc2c
165
15
bad96847-65f0-40bc-be35-8d593764ca18
6cad040e-509d-46a8-8108-4be98c183541
-60
-45
10
10
bad96847-65f0-40bc-be35-8d593764ca18
96626c10-e852-42e3-a001-4549cb7f4623
-60
105
10
10
bad96847-65f0-40bc-be35-8d593764ca18
ae19573b-2e87-4637-a274-25d168e78680
240
15
10
10
bad96847-65f0-40bc-be35-8d593764ca18
fec20de6-d538-4b3b-a925-a47cc306937f
165
60
10
10
bad96847-65f0-40bc-be35-8d593764ca18
96626c10-e852-42e3-a001-4549cb7f4623
15
60
10
10
bad96847-65f0-40bc-be35-8d593764ca18
cb024b07-868b-49ce-858f-9b8d0531a272
ae19573b-2e87-4637-a274-25d168e78680
165
105
bad96847-65f0-40bc-be35-8d593764ca18
b525bd2a-9970-40fa-b567-16834c27cbc0
165
150
10
10
bad96847-65f0-40bc-be35-8d593764ca18
f6038a48-f7cd-45a9-880c-b3834cfdfe80
15
150
10
10
bad96847-65f0-40bc-be35-8d593764ca18
756ddf3a-99de-4ca6-bdbd-c3fee1a9df13
240
105
10
10
bad96847-65f0-40bc-be35-8d593764ca18
32cbf4a3-1b4d-4ca8-bc8e-683ca1157bb8
240
255
10
10
bad96847-65f0-40bc-be35-8d593764ca18
32cbf4a3-1b4d-4ca8-bc8e-683ca1157bb8
15
195
bad96847-65f0-40bc-be35-8d593764ca18
3689f512-b76e-4c1d-adb8-07d0367aabfe
88b62fd7-41a8-4bc7-806a-bd8e1b5497ca
15
255
a487438c-3391-4a66-a1a6-5f40ebc64115
This stage compliments the Begin Transaction stage and makes all the changes made to the database since the transaction began permanent.
-195
-105
150
60
a487438c-3391-4a66-a1a6-5f40ebc64115
94e929e2-3231-4b8f-b0ae-de11c09eb76d
15
-210
a487438c-3391-4a66-a1a6-5f40ebc64115
15
150
a487438c-3391-4a66-a1a6-5f40ebc64115
flag
-225
0
a487438c-3391-4a66-a1a6-5f40ebc64115
text
-165
0
a487438c-3391-4a66-a1a6-5f40ebc64115
flag
-225
75
a487438c-3391-4a66-a1a6-5f40ebc64115
text
-165
75
a487438c-3391-4a66-a1a6-5f40ebc64115
1024802e-1bc7-413e-a614-5fb979be08e9
a49ce9aa-12b2-4283-af07-713e9267f698
15
-150
90
30
a487438c-3391-4a66-a1a6-5f40ebc64115
fac1dbed-718a-4386-9328-dc305b7ac7d5
15
-90
a487438c-3391-4a66-a1a6-5f40ebc64115
6dd9fd73-0fdb-4728-9802-e4dccf3cfef8
15
-30
a487438c-3391-4a66-a1a6-5f40ebc64115
590371f6-974e-4815-86a8-67942e585fa8
f64b457a-dfb7-4200-9a9f-5dd147561478
15
30
a487438c-3391-4a66-a1a6-5f40ebc64115
c954c31b-e736-4bb0-b994-4b9ed1ec5ab4
88b62fd7-41a8-4bc7-806a-bd8e1b5497ca
15
90
a487438c-3391-4a66-a1a6-5f40ebc64115
8e59ca16-e536-4c5e-9241-fd0c51914997
135
-150
a487438c-3391-4a66-a1a6-5f40ebc64115
6dd9fd73-0fdb-4728-9802-e4dccf3cfef8
135
30
10
10
540e741c-c8b3-4b39-9574-4abc24bd8bc9
This stage takes an SQL command and passes it to the database. Data items capture the success of the execution.
-195
-105
150
60
540e741c-c8b3-4b39-9574-4abc24bd8bc9
0813c4d4-7de4-4684-a88e-57f6ca904fce
15
-90
540e741c-c8b3-4b39-9574-4abc24bd8bc9
15
150
540e741c-c8b3-4b39-9574-4abc24bd8bc9
flag
False
-195
45
120
30
540e741c-c8b3-4b39-9574-4abc24bd8bc9
text
-195
90
120
30
540e741c-c8b3-4b39-9574-4abc24bd8bc9
text
-195
-30
540e741c-c8b3-4b39-9574-4abc24bd8bc9
flag
-225
165
90
30
540e741c-c8b3-4b39-9574-4abc24bd8bc9
text
-150
165
90
30
540e741c-c8b3-4b39-9574-4abc24bd8bc9
1ee380a9-7288-42c3-a7f7-5b7b867e7ddd
15
-30
540e741c-c8b3-4b39-9574-4abc24bd8bc9
a232f17d-eb06-431c-9038-6737f8dc27b1
a2317feb-7a3f-43cd-9630-f658abf0132c
15
30
540e741c-c8b3-4b39-9574-4abc24bd8bc9
d2d388d8-b1b2-48b1-9a3a-819c33e65bfb
88b62fd7-41a8-4bc7-806a-bd8e1b5497ca
15
90
540e741c-c8b3-4b39-9574-4abc24bd8bc9
c23f3cee-9332-483c-9958-a778ed907c44
f64b457a-dfb7-4200-9a9f-5dd147561478
105
30
540e741c-c8b3-4b39-9574-4abc24bd8bc9
2d996066-041b-479f-90f8-ec92b75f48de
165
30
10
10
540e741c-c8b3-4b39-9574-4abc24bd8bc9
a232f17d-eb06-431c-9038-6737f8dc27b1
165
90
10
10
032119f9-342d-4b7e-ab12-c018b781a2f3
This function executes an SQL script and returns a single numeric value.
-195
-105
150
90
032119f9-342d-4b7e-ab12-c018b781a2f3
48fa6d08-a0dc-4c5f-8429-6b3cbd113488
15
-135
032119f9-342d-4b7e-ab12-c018b781a2f3
15
225
032119f9-342d-4b7e-ab12-c018b781a2f3
80a533b4-febb-4c46-ba06-917a4b6357f7
d7f92fab-b3c7-4c06-ae2d-503e20b73fd7
15
-75
032119f9-342d-4b7e-ab12-c018b781a2f3
number
0
-195
150
120
30
032119f9-342d-4b7e-ab12-c018b781a2f3
flag
False
-195
60
120
30
032119f9-342d-4b7e-ab12-c018b781a2f3
text
-195
105
120
30
032119f9-342d-4b7e-ab12-c018b781a2f3
flag
-195
225
120
30
032119f9-342d-4b7e-ab12-c018b781a2f3
text
-195
270
120
30
032119f9-342d-4b7e-ab12-c018b781a2f3
text
-195
-15
120
30
032119f9-342d-4b7e-ab12-c018b781a2f3
39b89cf7-5815-4375-92b6-41642be882bf
56dba29f-03e1-4022-ad8a-2ec6f22e7756
15
-15
032119f9-342d-4b7e-ab12-c018b781a2f3
980361a8-5100-43e6-9a2e-769382e5f8ca
( SQL, Success, Message);]]>
15
45
032119f9-342d-4b7e-ab12-c018b781a2f3
5940f7d2-8ffc-475d-8b0f-5c2c6d53feea
c31a4854-aecd-4985-a9e7-aea16c8003b7
15
105
032119f9-342d-4b7e-ab12-c018b781a2f3
89f57094-f59a-43aa-987f-446f205a5077
88b62fd7-41a8-4bc7-806a-bd8e1b5497ca
15
165
032119f9-342d-4b7e-ab12-c018b781a2f3
26500a11-bbce-44c3-8e45-68ca85d69d54
f64b457a-dfb7-4200-9a9f-5dd147561478
105
105
032119f9-342d-4b7e-ab12-c018b781a2f3
26500a11-bbce-44c3-8e45-68ca85d69d54
165
-15
10
10
032119f9-342d-4b7e-ab12-c018b781a2f3
a6706a91-6a56-4275-a7b1-03dd1cb25589
165
105
10
10
032119f9-342d-4b7e-ab12-c018b781a2f3
5940f7d2-8ffc-475d-8b0f-5c2c6d53feea
165
165
10
10
48d79c6a-7dc2-4a23-a601-7421f7fb5280
This function executes an SQL script and returns a text result.
-195
-105
150
90
48d79c6a-7dc2-4a23-a601-7421f7fb5280
fc305383-c47a-4f28-a7d7-ad80b28d2b13
15
-135
48d79c6a-7dc2-4a23-a601-7421f7fb5280
15
225
48d79c6a-7dc2-4a23-a601-7421f7fb5280
2266b86c-83df-475b-9aa3-f4f63809de2d
d7f92fab-b3c7-4c06-ae2d-503e20b73fd7
15
-75
48d79c6a-7dc2-4a23-a601-7421f7fb5280
text
-195
150
120
30
48d79c6a-7dc2-4a23-a601-7421f7fb5280
flag
False
-195
60
120
30
48d79c6a-7dc2-4a23-a601-7421f7fb5280
text
-195
105
120
30
48d79c6a-7dc2-4a23-a601-7421f7fb5280
flag
-195
225
120
30
48d79c6a-7dc2-4a23-a601-7421f7fb5280
text
-195
270
120
30
48d79c6a-7dc2-4a23-a601-7421f7fb5280
text
-195
-15
120
30
48d79c6a-7dc2-4a23-a601-7421f7fb5280
0f9a8e20-7efd-4d78-8ef9-6befbaf29b01
f912cd86-1564-408d-8a47-cd02b3fe7e1f
15
-15
48d79c6a-7dc2-4a23-a601-7421f7fb5280
a36204ca-bbc5-49a9-a110-cce06b0b6301
( SQL, Success, Message);]]>
15
45
48d79c6a-7dc2-4a23-a601-7421f7fb5280
364d6551-8415-4474-be5b-df96c30edef3
780dcffe-6d6d-45cc-a023-9a0836f639aa
15
105
48d79c6a-7dc2-4a23-a601-7421f7fb5280
d42242fc-d402-4c94-8156-6ca9096507e1
88b62fd7-41a8-4bc7-806a-bd8e1b5497ca
15
165
48d79c6a-7dc2-4a23-a601-7421f7fb5280
b0d0782a-9018-49b6-bb6d-2c458e02a802
f64b457a-dfb7-4200-9a9f-5dd147561478
105
105
48d79c6a-7dc2-4a23-a601-7421f7fb5280
b0d0782a-9018-49b6-bb6d-2c458e02a802
165
-15
10
10
48d79c6a-7dc2-4a23-a601-7421f7fb5280
9a0b5862-76d6-42c6-95a2-875461b74ec8
165
105
10
10
48d79c6a-7dc2-4a23-a601-7421f7fb5280
364d6551-8415-4474-be5b-df96c30edef3
165
165
10
10
a05c17eb-69e9-4f1e-b50c-cc1c353eef22
This function executes a SQL Select statement and returns the resulting records in a Blue Prism collection data item.
-195
-105
150
60
a05c17eb-69e9-4f1e-b50c-cc1c353eef22
40c0811e-c5c9-4433-b02f-cc795a22f26a
15
-135
a05c17eb-69e9-4f1e-b50c-cc1c353eef22
15
225
a05c17eb-69e9-4f1e-b50c-cc1c353eef22
3596eb65-1f27-439f-aad3-3da420a8078d
d7f92fab-b3c7-4c06-ae2d-503e20b73fd7
15
-75
a05c17eb-69e9-4f1e-b50c-cc1c353eef22
flag
False
-195
60
120
30
a05c17eb-69e9-4f1e-b50c-cc1c353eef22
text
-195
105
120
30
a05c17eb-69e9-4f1e-b50c-cc1c353eef22
flag
-195
225
120
30
a05c17eb-69e9-4f1e-b50c-cc1c353eef22
text
-195
270
120
30
a05c17eb-69e9-4f1e-b50c-cc1c353eef22
text
-195
-15
120
30
a05c17eb-69e9-4f1e-b50c-cc1c353eef22
51a80d5e-ed7d-43bc-96c9-118c71f92637
3282ef5a-d68c-4ed7-8307-d6c0e2d1515b
15
-15
a05c17eb-69e9-4f1e-b50c-cc1c353eef22
08606669-e6ea-47f0-acb8-969844af72d8
15
45
a05c17eb-69e9-4f1e-b50c-cc1c353eef22
7239b88e-d964-400e-80f5-6ca9075ac40f
37376e9b-7fe2-4810-bbae-c8e516aebace
15
105
a05c17eb-69e9-4f1e-b50c-cc1c353eef22
4f5ac921-1a02-42f0-880d-2206482112c8
88b62fd7-41a8-4bc7-806a-bd8e1b5497ca
15
165
a05c17eb-69e9-4f1e-b50c-cc1c353eef22
2b46f726-d781-487f-8895-e751d6767902
f64b457a-dfb7-4200-9a9f-5dd147561478
105
105
a05c17eb-69e9-4f1e-b50c-cc1c353eef22
2b46f726-d781-487f-8895-e751d6767902
165
-15
10
10
a05c17eb-69e9-4f1e-b50c-cc1c353eef22
f16519c7-17cc-406f-b017-3b55cf4cd2a5
165
105
10
10
a05c17eb-69e9-4f1e-b50c-cc1c353eef22
7239b88e-d964-400e-80f5-6ca9075ac40f
165
165
10
10
a05c17eb-69e9-4f1e-b50c-cc1c353eef22
collection
-195
150
120
30
4e9c1383-a686-4fbc-9e3c-c11c8ade88af
This function takes a valid SQL Select query and returns the results to a CSV (Comma Separated Variable) file.
-180
-105
180
60
4e9c1383-a686-4fbc-9e3c-c11c8ade88af
388c8194-db84-4531-a96c-771cf32e890c
15
-135
4e9c1383-a686-4fbc-9e3c-c11c8ade88af
15
225
4e9c1383-a686-4fbc-9e3c-c11c8ade88af
cefc8354-fed0-4b02-9e2f-aaa3a15f03cd
d7f92fab-b3c7-4c06-ae2d-503e20b73fd7
15
-75
4e9c1383-a686-4fbc-9e3c-c11c8ade88af
flag
False
-225
225
4e9c1383-a686-4fbc-9e3c-c11c8ade88af
text
-135
225
4e9c1383-a686-4fbc-9e3c-c11c8ade88af
flag
-180
105
120
30
4e9c1383-a686-4fbc-9e3c-c11c8ade88af
text
-180
150
120
30
4e9c1383-a686-4fbc-9e3c-c11c8ade88af
text
-180
-15
120
30
4e9c1383-a686-4fbc-9e3c-c11c8ade88af
66114a6f-b706-42a9-a932-1a5fc4891b3f
43cf3da7-04f9-4c2f-a8eb-9f6819d6b8ca
15
-15
4e9c1383-a686-4fbc-9e3c-c11c8ade88af
fd8fc231-698c-428c-b4ed-7431456df3e2
15
45
4e9c1383-a686-4fbc-9e3c-c11c8ade88af
e9fd0d92-adc6-4fb4-bf55-0e454fc4246d
613c3098-d8ed-42d2-b652-380ceb778b4f
15
105
4e9c1383-a686-4fbc-9e3c-c11c8ade88af
e43d906f-9435-4acd-8c86-fa305ba62e2e
88b62fd7-41a8-4bc7-806a-bd8e1b5497ca
15
165
4e9c1383-a686-4fbc-9e3c-c11c8ade88af
63ed4515-04b7-453f-96fc-2c7c6314af4c
f64b457a-dfb7-4200-9a9f-5dd147561478
105
105
4e9c1383-a686-4fbc-9e3c-c11c8ade88af
63ed4515-04b7-453f-96fc-2c7c6314af4c
165
-15
10
10
4e9c1383-a686-4fbc-9e3c-c11c8ade88af
71fca5d6-6b2f-4874-90d0-942f08b2410e
165
105
10
10
4e9c1383-a686-4fbc-9e3c-c11c8ade88af
e9fd0d92-adc6-4fb4-bf55-0e454fc4246d
165
165
10
10
4e9c1383-a686-4fbc-9e3c-c11c8ade88af
text
-180
30
90
30
d2d014d5-71ff-47d1-8a2d-adf47aa96ab6
This function takes a valid SQL Select query and returns the results to a string in comma separated format.
-195
-105
150
90
d2d014d5-71ff-47d1-8a2d-adf47aa96ab6
113c2906-45ac-4a95-9c7f-30bff869064b
15
-135
d2d014d5-71ff-47d1-8a2d-adf47aa96ab6
15
225
d2d014d5-71ff-47d1-8a2d-adf47aa96ab6
6666b9d4-5648-48d6-9a1e-3b0d2d020d76
d7f92fab-b3c7-4c06-ae2d-503e20b73fd7
15
-75
d2d014d5-71ff-47d1-8a2d-adf47aa96ab6
flag
False
-195
60
120
30
d2d014d5-71ff-47d1-8a2d-adf47aa96ab6
text
-195
105
120
30
d2d014d5-71ff-47d1-8a2d-adf47aa96ab6
flag
-195
225
120
30
d2d014d5-71ff-47d1-8a2d-adf47aa96ab6
text
-195
270
120
30
d2d014d5-71ff-47d1-8a2d-adf47aa96ab6
text
-195
-15
120
30
d2d014d5-71ff-47d1-8a2d-adf47aa96ab6
64e864ea-1b10-4a6e-95af-0e0a3fe0628d
ef26ed02-b966-4f1b-b84d-2c9e912133de
15
-15
d2d014d5-71ff-47d1-8a2d-adf47aa96ab6
fa17e58a-8fe4-4953-9d42-f6fe8b42bf71
15
45
d2d014d5-71ff-47d1-8a2d-adf47aa96ab6
f733dbe1-b8d8-481c-bb02-fae9eed564df
a45065ea-6cbf-492b-acb4-ced63a2c86d2
15
105
d2d014d5-71ff-47d1-8a2d-adf47aa96ab6
84e90fc2-6e87-4152-89fb-73b1a4f2fb6a
88b62fd7-41a8-4bc7-806a-bd8e1b5497ca
15
165
d2d014d5-71ff-47d1-8a2d-adf47aa96ab6
5747aa0b-297d-4eb5-908e-5885a55ca3c7
f64b457a-dfb7-4200-9a9f-5dd147561478
105
105
d2d014d5-71ff-47d1-8a2d-adf47aa96ab6
5747aa0b-297d-4eb5-908e-5885a55ca3c7
165
-15
10
10
d2d014d5-71ff-47d1-8a2d-adf47aa96ab6
a8653c1c-8515-4275-9b7d-5f6408af6c8e
165
105
10
10
d2d014d5-71ff-47d1-8a2d-adf47aa96ab6
f733dbe1-b8d8-481c-bb02-fae9eed564df
165
165
10
10
d2d014d5-71ff-47d1-8a2d-adf47aa96ab6
text
-195
150
90
30
43d80e10-0a8d-46f4-abcb-19fcbd68fc6b
This function returns the currently logged on user. This is an environment value and not a value from Oracle.
-195
-105
150
90
43d80e10-0a8d-46f4-abcb-19fcbd68fc6b
8ffc9cf0-b802-4d60-8aec-de10b8f0b0d0
-45
-120
43d80e10-0a8d-46f4-abcb-19fcbd68fc6b
-45
30
43d80e10-0a8d-46f4-abcb-19fcbd68fc6b
a4ee627b-6d62-4671-acde-20e0ae9aeb81
-45
-45
90
60
43d80e10-0a8d-46f4-abcb-19fcbd68fc6b
text
-195
0
120
30
5c204a77-ccc6-45cd-a3be-936abb251c49
This function returns the value of the current machine name where the user is logged on to. This is not a value from Oracle.
-195
-105
150
90
5c204a77-ccc6-45cd-a3be-936abb251c49
03f3bcd3-9a22-4e4b-94bc-70a894c4707c
15
-105
5c204a77-ccc6-45cd-a3be-936abb251c49
15
45
5c204a77-ccc6-45cd-a3be-936abb251c49
5b285524-8427-471c-8eb8-605a7cd5e029
15
-30
90
30
5c204a77-ccc6-45cd-a3be-936abb251c49
text
-195
0
120
30
15d519d8-1803-4720-821c-3ccea40d8273
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.
-195
-105
150
90
15d519d8-1803-4720-821c-3ccea40d8273
29a0807c-b1e3-4a45-952a-c9bbb695a633
15
-105
15d519d8-1803-4720-821c-3ccea40d8273
15
15
15d519d8-1803-4720-821c-3ccea40d8273
text
-195
30
90
30
15d519d8-1803-4720-821c-3ccea40d8273
flag
-195
-15
90
30
15d519d8-1803-4720-821c-3ccea40d8273
973f071b-5bef-432d-9407-d85c1eb63722
540e741c-c8b3-4b39-9574-4abc24bd8bc9
15
-45
15d519d8-1803-4720-821c-3ccea40d8273
flag
-195
150
15d519d8-1803-4720-821c-3ccea40d8273
text
-195
105
ba1c8e81-ef16-4940-a993-09fe604cda76
This removes the complete set of rows in a table. This function requires some database schema knowledge.
-195
-105
150
90
ba1c8e81-ef16-4940-a993-09fe604cda76
79f2e688-1138-4bfc-96ea-a97be9ee5062
15
-105
ba1c8e81-ef16-4940-a993-09fe604cda76
15
15
ba1c8e81-ef16-4940-a993-09fe604cda76
text
-195
-15
90
30
ba1c8e81-ef16-4940-a993-09fe604cda76
810653df-7002-483e-bd15-388d2bd7b173
540e741c-c8b3-4b39-9574-4abc24bd8bc9
15
-45
ba1c8e81-ef16-4940-a993-09fe604cda76
flag
-195
105
ba1c8e81-ef16-4940-a993-09fe604cda76
text
-195
60
379163bf-d2ab-47d2-9132-1827ccf80e66
This function will delete a set of records from a table where the where clause is satisfied. This function requires some database schema knowledge.
-195
-105
150
90
379163bf-d2ab-47d2-9132-1827ccf80e66
a0ca44e4-5160-46ce-b265-d4c17d48dc29
15
-105
379163bf-d2ab-47d2-9132-1827ccf80e66
15
15
379163bf-d2ab-47d2-9132-1827ccf80e66
text
-195
-15
120
30
379163bf-d2ab-47d2-9132-1827ccf80e66
text
-195
30
120
30
379163bf-d2ab-47d2-9132-1827ccf80e66
e5d21f2c-63ed-4102-ad19-bf32e7c1322d
540e741c-c8b3-4b39-9574-4abc24bd8bc9
15
-45
379163bf-d2ab-47d2-9132-1827ccf80e66
text
-195
165
379163bf-d2ab-47d2-9132-1827ccf80e66
flag
-195
120
d7f92fab-b3c7-4c06-ae2d-503e20b73fd7
19556310-2b41-422d-af21-e3c6458d1dfe
241b279e-d44c-422b-9421-669b95323468
15
-45
4e9c1383-a686-4fbc-9e3c-c11c8ade88af
-270
195
180
60
4e9c1383-a686-4fbc-9e3c-c11c8ade88af
-270
-45
180
105
4e9c1383-a686-4fbc-9e3c-c11c8ade88af
-270
75
180
105
75
-195
210
450
ccacb83a-6ee1-4fc5-9c2b-d09215a4f561
-300
-45
210
60
88b62fd7-41a8-4bc7-806a-bd8e1b5497ca
-270
-15
150
60
241b279e-d44c-422b-9421-669b95323468
-270
-45
150
90
f64b457a-dfb7-4200-9a9f-5dd147561478
-255
75
120
60
f64b457a-dfb7-4200-9a9f-5dd147561478
-255
-45
120
105
bad96847-65f0-40bc-be35-8d593764ca18
-255
75
120
60
bad96847-65f0-40bc-be35-8d593764ca18
-255
-45
120
105
a487438c-3391-4a66-a1a6-5f40ebc64115
-270
45
150
60
a487438c-3391-4a66-a1a6-5f40ebc64115
-270
-45
150
75
fe9fac62-8a9a-4b7d-846c-418f73082557
-270
75
150
75
fe9fac62-8a9a-4b7d-846c-418f73082557
-270
-45
150
105
540e741c-c8b3-4b39-9574-4abc24bd8bc9
-270
135
180
60
540e741c-c8b3-4b39-9574-4abc24bd8bc9
-270
15
150
105
540e741c-c8b3-4b39-9574-4abc24bd8bc9
-270
-60
150
60
032119f9-342d-4b7e-ab12-c018b781a2f3
-270
195
150
105
032119f9-342d-4b7e-ab12-c018b781a2f3
-270
30
150
150
032119f9-342d-4b7e-ab12-c018b781a2f3
-270
-45
150
60
48d79c6a-7dc2-4a23-a601-7421f7fb5280
-270
195
150
105
48d79c6a-7dc2-4a23-a601-7421f7fb5280
-270
30
150
150
48d79c6a-7dc2-4a23-a601-7421f7fb5280
-270
-45
150
60
a05c17eb-69e9-4f1e-b50c-cc1c353eef22
-270
195
150
105
a05c17eb-69e9-4f1e-b50c-cc1c353eef22
-270
30
150
150
a05c17eb-69e9-4f1e-b50c-cc1c353eef22
-270
-45
150
60
d2d014d5-71ff-47d1-8a2d-adf47aa96ab6
-270
195
150
105
d2d014d5-71ff-47d1-8a2d-adf47aa96ab6
-270
30
150
150
d2d014d5-71ff-47d1-8a2d-adf47aa96ab6
-270
-45
150
60
379163bf-d2ab-47d2-9132-1827ccf80e66
-270
75
150
135
379163bf-d2ab-47d2-9132-1827ccf80e66
-270
-45
150
105
15d519d8-1803-4720-821c-3ccea40d8273
-270
75
150
105
15d519d8-1803-4720-821c-3ccea40d8273
-270
-45
150
105
ba1c8e81-ef16-4940-a993-09fe604cda76
-270
30
150
105
ba1c8e81-ef16-4940-a993-09fe604cda76
-270
-45
150
60
43d80e10-0a8d-46f4-abcb-19fcbd68fc6b
-270
-45
150
90
5c204a77-ccc6-45cd-a3be-936abb251c49
-270
-45
150
90