topic RE: Oracle Connection in Product Forum

Oracle Connection

aseelodeh — Thu, 23 Jun 2022 10:00:00 GMT

Hi all,

I want to connect to oracle DB from a client machine, I'm using OLEDB VBO to do this, the error is showing that the"'OraOLEDB.Oracle' provider is not registered on the local machine."

I'm stuck in downloading the ODAC, can anyone help, please.

------------------------------
aseel odeh
------------------------------

RE: Oracle Connection

devneetmohanty07 — Thu, 23 Jun 2022 10:26:00 GMT

Hi Aseel,

For interacting with Oracle database, we have a different asset in Digital Exchange I believe: Function for Oracle MDA - Utility - 1.1.0

Try this business object instead and let us know if it works. You can find the guide required to use this asset properly on the asset page itself.

Also, I am providing you some reference threads that also you can follow in case you face any issues while using this asset:

1) Getting Data from Oracle Database
2) Oracle MDA Utility issue

------------------------------
----------------------------------
Hope it helps you out and if my solution resolves your query, then please mark it as the 'Best Answer' so that the others members in the community having similar problem statement can track the answer easily in future

Regards,
Devneet Mohanty
Intelligent Process Automation Consultant | Sr. Consultant - Automation Developer,
WonderBotz India Pvt. Ltd.
Blue Prism Community MVP | Blue Prism 7x Certified Professional
Website: https://devneet.github.io/
Email: devneetmohanty07@gmail.com

----------------------------------
------------------------------

RE: Oracle Connection

aseelodeh — Thu, 23 Jun 2022 10:36:00 GMT

Thanks for your answer, I tried it but this error has occurred

------------------------------
aseel odeh
------------------------------

RE: Oracle Connection

devneetmohanty07 — Thu, 23 Jun 2022 10:44:00 GMT

Hi Aseel,

Please check the asset page along with the threads which I mentioned to ensure you have all the pre-requisites in place first as this asset needs additional DLL's to be added in order to work and you might require to download them from Nuget Feed

This wont be a direct plug and play asset and also I would suggest you to show us the exact errors from your error compiler window to get more details on the same.

------------------------------
----------------------------------
Hope it helps you out and if my solution resolves your query, then please mark it as the 'Best Answer' so that the others members in the community having similar problem statement can track the answer easily in future

Regards,
Devneet Mohanty
Intelligent Process Automation Consultant | Sr. Consultant - Automation Developer,
WonderBotz India Pvt. Ltd.
Blue Prism Community MVP | Blue Prism 7x Certified Professional
Website: https://devneet.github.io/
Email: devneetmohanty07@gmail.com

----------------------------------
------------------------------

RE: Oracle Connection

aseelodeh — Thu, 23 Jun 2022 10:51:00 GMT

The error is about the Oracle.ManagedDataAccess.dll file, am I supposed to locate it in a specific location? it's installed already

------------------------------
aseel odeh
------------------------------

RE: Oracle Connection

devneetmohanty07 — Thu, 23 Jun 2022 13:34:00 GMT

Hi Aseel,

This DLL must be present in your oracle ODAP installation folder. You can try to copy that and paste it in your Blue Prism installation folder. If you are unable to find the DLL, then you can download the same from the Oracle.ManagedDataAccess Nuget Feed

------------------------------
----------------------------------
Hope it helps you out and if my solution resolves your query, then please mark it as the 'Best Answer' so that the others members in the community having similar problem statement can track the answer easily in future

Regards,
Devneet Mohanty
Intelligent Process Automation Consultant | Sr. Consultant - Automation Developer,
WonderBotz India Pvt. Ltd.
Blue Prism Community MVP | Blue Prism 7x Certified Professional
Website: https://devneet.github.io/
Email: devneetmohanty07@gmail.com

----------------------------------
------------------------------

RE: Oracle Connection

Neel1 — Fri, 24 Jun 2022 12:31:00 GMT

Hello - How is it different from ODBC one in term of capability, speed etc?

------------------------------
Neeraj Kumar
Technical Architect
------------------------------

RE: Oracle Connection

Neel1 — Fri, 24 Jun 2022 17:58:00 GMT

Hello - Neverminded i used this and this is awesome.

1. Much faster then ODBC.
2. extra action/feature
3. Require less action stage to get the o/p

------------------------------
Neeraj Kumar
Technical Architect
------------------------------

Re: RE: Oracle Connection

Sangjun — Mon, 29 Apr 2024 06:45:59 GMT

Dear Mohanty, Your comments are very helpful for me.

I also have had a problem like above to connect Oracle DBMS, and I get issue-shooted for your kind comments.

I wonder if I ask another question to you that Function for Oracle MDA - Utility - 1.1.0 does not have an action, "Close Connection".

Is it ok not to close the connection after connecting and excuting some queries?

I wonder if Function for Oracle MDA - Utility - 1.1.0 has a auto-closing connection function?