And did you happen to check the exception details from locals panel by running in debug mode that will help in understanding the error better …generally it might have more info about what exactly errored out
Apparently it is a problem with the CLOB data type in oracle. If selecting a column which is a CLOB column, UiPath Run Query activity returns this ORA-12537 error. Must cast to VARCHAR2. Anyway, Database package may have issues with CLOB types.