topic RE: Oracle Standard VBO in Product Forum

Oracle Standard VBO

Anonymous — Fri, 21 Jun 2019 12:37:00 GMT

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
------------------------------

RE: Oracle Standard VBO

AmiBarrett — Fri, 21 Jun 2019 15:35:00 GMT

The main problem with Oracle, is that no view is standardized; it's all custom-built for front-end interaction. About all you could get out of standard actions would be to close, select a favorite, or trigger something from one of the pull-down menus at the top (IE: Export, but that would then need a second object to handle the remaining section in IE).

The other major issue with Oracle, at least in the version I work with, is that none of the definitions are consistent. Items that should be static (New item, Search, etc) still don't contain reliable definitions all the time, because Oracle (Java?) likes to change how it gets rendered. You're honestly probably going to be better off making your own object, then making use of Region mode for a few items.

------------------------------
Ami Barrett
Lead RPA Software Developer
Solai & Cameron
America/Chicago
------------------------------

RE: Oracle Standard VBO

kazumasayoshika — Mon, 23 Aug 2021 07:28:00 GMT

Which would be the current standard VBO?

------------------------------
kazumasa yoshikawa
------------------------------

RE: Oracle Standard VBO

michaeloneil — Mon, 23 Aug 2021 08:34:00 GMT

Hi Kazumasa

The standard vbo in Blueprism for working with databases is Data - OLEDB, the functionality allows you to execute your sql queries. What exactly is it you're trying to do with oracle?

------------------------------
Michael ONeil
Technical Lead developer
Everis Consultancy
Europe/London
------------------------------

RE: Oracle Standard VBO

ewilson — Mon, 23 Aug 2021 17:05:00 GMT

Hi Ankit,

There's a lot of "Oracle" out there. Are you referring to Oracle RDBMS or any of the many Oracle products/platforms out there? If you are referring to Oracle RDBMS then there is an Oracle RDBMS VBO on the Digital Exchange that makes use of the Oracle ODP.NET library. You can find it here.

There are also assets on the DX for working with Oracle Integration Cloud and Oracle ERP.

Cheers,

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

RE: Oracle Standard VBO

kazumasayoshika — Tue, 24 Aug 2021 02:59:00 GMT

Hi Eric,

Yes, I mean the Oracle RDBMS.
I want to connect to the DB and perform basic table operations (UPDATE, INSERT, DELETE).

Thank you for introducing me to Oracle RDBMS VBO.
One question, where can I get the prerequisite Oracle.ManagedDataAccess.dll?

------------------------------
kazumasa yoshikawa
------------------------------

RE: Oracle Standard VBO

ewilson — Tue, 24 Aug 2021 03:10:00 GMT

You should be able to find it here.

Cheers,

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

RE: Oracle Standard VBO

kazumasayoshika — Tue, 24 Aug 2021 04:47:00 GMT

It was very helpful. Thank you very much.
I was able to get the DLL safely.

------------------------------
kazumasa yoshikawa
------------------------------

RE: Oracle Standard VBO

sonuiiml — Tue, 24 Aug 2021 12:30:00 GMT

Hi Ankit,
I was able to connect to to ORracle 11g databse and perform the operations there. So essentially, the requirement was to execute custom stored procedures in Oracle database and there was some amount so C# coding involved to execute those. Well it worked really well for me. Below is the link to the utility tool in digital exchange

Blue Prism Digital Exchange

All you need to do is to place Oraclemanagedaccess.dll in the blueprism automate folder.

Let me know if you have any questions.

Thanks & Regards,

Susamay Halder

+1(437)217-1086

------------------------------
Susamay Halder Consultant
Consultant
Bruce Power
+1(437)217-1086
------------------------------

RE: Oracle Standard VBO

blake — Wed, 25 Aug 2021 14:02:00 GMT

RE: Oracle Standard VBO

ewilson — Wed, 25 Aug 2021 14:09:00 GMT

@blake,

What version of Blue Prism are you using, and did you copy the Oracle DLL into the Blue Prism Automate folder?

Cheers,

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

RE: Oracle Standard VBO

blake — Wed, 25 Aug 2021 14:38:00 GMT

Blue Prism

RE: Oracle Standard VBO

ewilson — Wed, 25 Aug 2021 16:55:00 GMT

@blake,

The netstandard error seems to be a hit or miss sort of thing. You can try adding the following line to the Code Options section of the Initialize tab:

Out of curiosity, what versions of the .NET Framework do you have installed?

Cheers,

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

RE: Oracle Standard VBO

PauloPolitti — Wed, 27 Oct 2021 20:03:00 GMT

Hi Eric, I have a similar error.

I can connect with the DB using the action DB Connect, but when attempting to use any other action. I get the following message:

(this page is for test only, don't mind the poor programming)

The test of the message is as follows:

Internal : Could not execute code stage because exception thrown by code stage: Could not load file or assembly 'netstandard, Version=2.1.0.0, Culture=neutral, PublicKeyToken=cc7b13ffcd2ddd51' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040)

The BP version I'm running is 6.10.0
The Oracle VBO version is the one in DX

I tried the following:

1st.- added the netstandard.dll reference to the Oracle Object.

2nd.- Reference the netstandard in the GAC instead the one in the BP directory.
didn{t work, rolled back the change and

3nd, Rename the Automate\netstandard.dll and copy the one in the GAC. Didn't work

It seems to me that the problem is the version of the dll.

Any help? Also, it is the customer enviroment and I have limited access to the runtime, so anything I want to try, I need to ask for.

The .NET version is 4.6

Thanks in advance

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

RE: Oracle Standard VBO

AdityaJain — Thu, 02 Dec 2021 05:50:00 GMT

@Paulo Politti: Have you find any solution for this? I am also facing the same issue.

@ewilson: Any update on the this requested query?

Thanks in advance,
Aditya

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

RE: Oracle Standard VBO

ewilson — Thu, 02 Dec 2021 10:35:00 GMT

@Paulo Politti, @AdityaJain1,

Do you known what version of the .Net Standard DLL is installed in your environments?

Cheers,

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

RE: Oracle Standard VBO

AdityaJain — Mon, 06 Dec 2021 05:35:00 GMT

Hi Eric,

Apologies for late reply.

We are using 4.6.25514.4 version of .netstandard DLL.

Thanks

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

RE: Oracle Standard VBO

ewilson — Mon, 06 Dec 2021 15:27:00 GMT

@Paulo Politti, @AdityaJain1,

The one thing you both have in common, which is slightly different from my environment, is the use of .NET v4.6. In my case I'm using v4.7. Do you have any test machines that you could install .NET v4.7 on and see if you have the same issue?

Cheers,

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

RE: Oracle Standard VBO

AdityaJain — Mon, 06 Dec 2021 16:42:00 GMT

HI Eric,

Thanks for your inputs. I have checked on my machine .NET 4.8 version is installed(PFB screenshot)

Also could you please let us know from where we can get .netstandard Version=2.1.0.0?

Thanks,

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

RE: Oracle Standard VBO

ewilson — Mon, 06 Dec 2021 17:10:00 GMT

.NET v4.8 may be installed, but that doesn't mean Blue Prism is using it. Take a look at the file Automate.exe.config in the Blue Prism Automate folder (you can open it with any text editor). Towards the top of the file you should see a reference to supportedRuntime (as pictured below). What version is listed on yours?

Cheers,

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