Running PL/SQL queries in Oracle MDA Master utility

[sonuiiml]

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#bm...

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

[ewilson]

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