I have spent weeks trying to figure out how to run PL/SQL to call Oracle stored procedures within Studio, each time getting a different error on each attempt. You can trace my requests for help in the forum.
Finally I realized that
a) The “Run command” (former "Execute Non Query; UiPath.Database.Activities.ExecuteNonQuery) activity is the one to be used for this,
b) Using the line “SET SERVEROUTPUT ON;” will make the script to fail. I thought it was just ignoring it or there was no way to get the output, but not only that but it will throw an error.
This should be stated somewhere in the docs. Althought it would be better to address it and let us use SERVEROUTPUT ON because several times it’s used to get the results of the execution.