we had problems connecting to oracle, got round it in the end by creating a linked server in SQL Server to the Oracle DB, and connecting to the SQL server box from Blue prism. So in this way SQL server was the middle man that passed on the query to oracle and fed the results back to blue prism.