Here is some additional information on that Oracle VBO:
There are a number of direct dll path references in the Code Options screen of the VBO. It is likely that you will need to change these paths to point to the .NET framework dll locations within your infastructure. Also, if you are using Blue Prism v5 you may want to point to .NET 4.0 dlls instead of .NET 2.0 dlls. For more information about code stages and references in Blue Prism you should refer to the relevant .NET framework data sheet in the product area of the portal.
Once the VBO is imported and the code references correct to use it take the following steps:
Make sure Oracle is closed (Close action)
Set the required connection (Set Connection action; Server, DB, User, Password)
Example Server String (though yours, obviously, will be different):
(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=)(PORT=1522)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=)))
Open the Oracle connection (Open action)
Run the queries (Get Collection, Execute, Begin/End Transaction, etc. actions)
Close the connection (Close action)
