Oracle Standard VBO

[Anonymous]

Hi Everyone,

I am working on a POC that involves Oracle. Is there any Oracle VBO, Can assist me?

------------------------------
Ankit Raj
RPA developer
EY
India
------------------------------

[AdityaJain]

PFB screenshot of Automate.exe.config file.



Thanks,

------------------------------
Aditya Jain
Senior RPA developer
Accenture
Asia/Kolkata
8058426934
------------------------------

[ewilson]

I think I know what's going on. I have a feeling the Oracle.ManagedDataAccess.dll you downloaded is actually the one that's built on the .NET Core platform as opposed to the one that's built on the .NET Framework. There is a difference, and that would explain why you're being asked to include the netstandard.dll.

Let's try downloading a different file. Go to this link:

https://download.oracle.com/otn/other/ole-oo4o/ODAC193Xcopy_32bit.zip

This is the 32-bit Managed ODAC 19.3 zip file. Once you've downloaded it, open the file and go to odp.net4 -> odp.net -> managed -> common. There you will find the Oracle.ManagedDataAccess.dll file. Extract that and copy it to your Blue Prism Automate folder. If Blue Prism is already running, you'll need to restart it. Then see if you get the same error.

Cheers,

------------------------------
Eric Wilson
Director, Integrations and Enablement
Blue Prism Digital Exchange
------------------------------

[ewilson]

@Paulo Politti, @AdityaJain1,

Any feedback on my recommendation above?

Cheers,



------------------------------
Eric Wilson
Director, Integrations and Enablement
Blue Prism Digital Exchange
------------------------------

[GeoffHirst]

Hi all,

Just for the record, as this asset was created by me, I thought I might chip in with what I have managed to get working.

I do not have netstandard in my Blue Prism Automate folder.

I have the following:

My laptop is Running Windows 10 Pro - 21H1 OS Build 19043.1348

I have the following versions of dotnet sdks installed.

2.1.701 [C:\Program Files\dotnet\sdk]
2.1.818 [C:\Program Files\dotnet\sdk]
3.1.415 [C:\Program Files\dotnet\sdk]
5.0.101 [C:\Program Files\dotnet\sdk]
5.0.103 [C:\Program Files\dotnet\sdk]
5.0.203 [C:\Program Files\dotnet\sdk]
5.0.209 [C:\Program Files\dotnet\sdk]
5.0.303 [C:\Program Files\dotnet\sdk]
5.0.401 [C:\Program Files\dotnet\sdk]
5.0.403 [C:\Program Files\dotnet\sdk]

.NET Depends view of my version of OracleManagedDataAccess is below.

In the event the image hasn't worked out, the version I have is 4.122.19.1.

Right now, this all works fine. No errors.

I hope this helps to clarify for those having issues.

regards



------------------------------
Geoff Hirst
Consultant - Digital Exchange - EMEA
Blue Prism
------------------------------

[AdityaJain]

HI Eric,

Apologies, i Was on long holiday.

yes post your suggestion, i was able to connect to Oracle data base and able to fetch data also but now when i am running query to get data, i am getting error. 
Could you please have a look at this?

Error msg :"ORA-00900: Ungültige SQL-Anweisung"(translation in English: ORA-00900: Invalid SQL statement).



Many thanks.

------------------------------
Aditya Jain
Senior RPA developer
Accenture
Asia/Kolkata
8058426934
------------------------------

[ewilson]

@AdityaJain1,

Try adding a semicolon to the end of your SQL statement.

Cheers,

​

------------------------------
Eric Wilson
Director, Integrations and Enablement
Blue Prism Digital Exchange
------------------------------

[AdityaJain]

HI Eric,

I have tried this already but result is same.


Thanks,

------------------------------
Aditya Jain
Senior RPA developer
Accenture
Asia/Kolkata
8058426934
------------------------------

[ewilson]

@AdityaJain1,

Without knowing the makeup of the database and that specific table it's hard to say. Do you have access to either the sqlplus​ utility or Oracle SQL Developer application? If so, can you run that same SQL query in them?

Cheers,

------------------------------
Eric Wilson
Director, Integrations and Enablement
Blue Prism Digital Exchange
------------------------------

[AdityaJain]

Hi Eric,

After reimporting the Oracle_MDA utility BPrelease file. when i tried to fetch the data from data base, i am able to fetch the data from database.

Thanks you so much for your constant support.

Regards,

------------------------------
Aditya Jain
Senior RPA developer
Accenture
Asia/Kolkata
8058426934
------------------------------

[PauloPolitti]

Hi Eric, sorry for the late reply. The environment where we're working is very restricted and took us a while to implement the recommendations.

Happy to say that they all worked well and we are able to use the .vba now.

Thanks for all the help on this issue.

------------------------------
Paulo Politti
------------------------------