I want to use the statement:
exec dbms_mview.refresh('testroy_mview', 'F')
in my after sql statement of an oracle stage (or in a new stage after the oracle stage).
The error i get is that my sql statement is invalid although i can run the statement in sql.
what's the easiest way to execute such a statement from datastage?
(because of the version of datastage at this customer i don't have the stored procedure stage , so that's no option)
How to call a DBMS routine in a after sql statement?
Moderators: chulett, rschirm, roy