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.
Execute (Oracle) stored procedure
Re: Execute (Oracle) stored procedure
Try to use the action "SQL Query" with such SQL expression:
begin
dbms_stats.gather_table_stats('<dbschema>', '<tablename>', cascade=>true,degree=>4);
end;
begin
dbms_stats.gather_table_stats('<dbschema>', '<tablename>', cascade=>true,degree=>4);
end;
Oleg Yershov
Re: Execute (Oracle) stored procedure
It works fine.
Thank you, Oleg.
Thank you, Oleg.