Question
How to run exec and grant command in fme like "exec dbms_stats.gather_table_stats(‘Schema_name’, ‘Table_name’)" and "GRANT SELECT ON table_Name TO public"
How to run exec and grant command in fme like "exec dbms_stats.gather_table_stats(‘Schema_name’, ‘Table_name’)" and "GRANT SELECT ON table_Name TO public"
+10- Safer
Hi @rohit
Have you tried running the SQLStatement using SQLCreator or SQLExecutor transformers?
Here is an article The SQLCreator and SQLExecutor Transformers that will be a good start.
rahulsharma wrote:
Hi @rohit
Have you tried running the SQLStatement using SQLCreator or SQLExecutor transformers?
Here is an article The SQLCreator and SQLExecutor Transformers that will be a good start.
yes, it ran successfully but didnot make any stats or even grant to public
Reply
Rich Text Editor, editor1
Editor toolbars
Press ALT 0 for help
Helpful Members This Week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.