Oracle Standard VBO

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
21-06-19 01:37 PM
I am working on a POC that involves Oracle. Is there any Oracle VBO, Can assist me?
------------------------------
Ankit Raj
RPA developer
EY
India
------------------------------
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
06-12-21 05:16 PM
Thanks,
------------------------------
Aditya Jain
Senior RPA developer
Accenture
Asia/Kolkata
8058426934
------------------------------
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
06-12-21 06:35 PM
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
------------------------------
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
08-12-21 04:34 PM
Any feedback on my recommendation above?
Cheers,
------------------------------
Eric Wilson
Director, Integrations and Enablement
Blue Prism Digital Exchange
------------------------------
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
08-12-21 06:33 PM
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
------------------------------
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
14-12-21 12:44 PM
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
------------------------------
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
14-12-21 12:55 PM
@AdityaJain1,
Try adding a semicolon to the end of your SQL statement.
Cheers,
------------------------------
Eric Wilson
Director, Integrations and Enablement
Blue Prism Digital Exchange
------------------------------
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
14-12-21 04:58 PM
I have tried this already but result is same.
Thanks,
------------------------------
Aditya Jain
Senior RPA developer
Accenture
Asia/Kolkata
8058426934
------------------------------
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
14-12-21 05:07 PM
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
------------------------------
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
23-12-21 04:13 AM
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
------------------------------
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
04-01-22 10:15 PM
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
------------------------------
