Execute exec statement before query (ToracleInput)

[Anonymous]

Hi Talend Community,

I would like to execute a  exec command to refresh a materialized view before executing a query on that view.

I get the error invalid sql statement when trying to execute the statement in Talend.(the query works in SQL developer)

The query looks like this in toracleinput:

"

exec dbms.mview.refresh('myMtable';

with tbl1 as (

query)

"

Any help would be appreciated

[manodwhb]

@mehmedie , can you execute in tOraclrow tat query and use on Component OK to tOralcinput execute your select query.

[Anonymous]

WIll try that. Thanks

[Anonymous]

in the toraclerow i get the same invalid sql statement error