Call Oracle DB function


#1

Hi,
How can I call Oracle DB function? I tried using “Execute non query”, but don’t find information how to receive result from function. Executing query and calling DB procedure without results works fine.

Regards,
Andrius


#2

Do you mean this?

Output
AffectedRecords

The result of the execution of the sql command. For UPDATE, INSERT, and DELETE statements, the return value is the number of rows affected by the command. For all other types of statements, the return value is -1.

https://www.uipath.com/activities-guide/execute-non-query


#3

No, I mean value returned from DB function call as return value or as out parameter from DB procedure call.
Function example:
create or replace function function_test(p1 in varchar2) return varchar2 is
begin
return ‘A’;
end;