Running PL/SQL queries in Oracle MDA Master utility

sonuiiml — Mon, 11 Jan 2021 18:10:00 GMT

Hi Team,

I am using Oracle MDA Master utility (Link Provided) to read data from Oracle databases and its working good.

Can I also run PL/SQL queries as well? Please let me know

Link to utility

https://community.blueprism.com/communities/community-home/digestviewer/viewthread?MessageKey=d08a36b5-47b7-4157-835d-7bef140ef73c&CommunityKey=3743dbaa-6766-4a4d-b7ed-9a98b6b1dd01&tab=digestviewer#bmd08a36b5-47b7-4157-835d-7bef140ef73c

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

RE: Running PL/SQL queries in Oracle MDA Master utility

ewilson — Fri, 15 Jan 2021 19:19:00 GMT

Hi @Susamay Halder,

I believe the answer is not at this time. It is possible to execute PL/SQL stored procedures with the Oracle MDAC library, but I think the VBO will need some extending to support it. The Execute action is currently designed to work with an input SQL statement. So either a new action will need to be created, or the existing action will need to be extended.

In either case, the code will need to account for setting the CommandType value to CommandType.StoredProcedure and handling any input values the stored procedure may need which means we will likely have to accept an input Collection.

Cheers,

------------------------------
Eric Wilson
Director, Partner Integrations for Digital Exchange
Blue Prism
------------------------------

topic RE: Running PL/SQL queries in Oracle MDA Master utility in Product Forum

Running PL/SQL queries in Oracle MDA Master utility

RE: Running PL/SQL queries in Oracle MDA Master utility