RoboTask forum

Hello,
how do I have to use Oracle stored procedures in Robotask?

Example:
exec dbms_stats.gather_table_stats('<dbschema>', '<tablename>', cascade=>true,degree=>4)

Doing this in "SQL Query" always causes an error.
Would the only way be doing it via using SQLPlus through an external batch file?

Any ideas?
Thank you.

Try to use the action "SQL Query" with such SQL expression:

begin
dbms_stats.gather_table_stats('<dbschema>', '<tablename>', cascade=>true,degree=>4);
end;

It works fine.
Thank you, Oleg.