How to gather statistics via CloverETL graph?

CloverDX Platform
1

Hello,

my issue is simple - I want to gather statistics after inserting/deleting data using SQL:

execute DBMS_STATS.gather_table_stats('<scheme>', '<table>')

When I use DBExecute component, the answer is

ORA-00900: invalid SQL statement

However when I run it in SQL Developer, the command is processed correctly.
I have the rights to run the command.

Appreciate any help.
Thanks a lot
Tomas

2

Hi Tomas

You need to use PL/SQL statement instead of plain SQL:

BEGIN
	DBMS_STATS.gather_table_stats('<scheme>', '<table>');
END;

Also you have to change the SQL statement delimiter to ^

I hope this helps.
Best regards

3

Thank you very much!!! It is working!
Perfect help - thanks a lot!
Tomas