topic Execute exec statement before query (ToracleInput) in Talend Studio

Execute exec statement before query (ToracleInput)

Anonymous — Sat, 16 Nov 2024 03:44:37 GMT

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 — Mon, 23 Dec 2019 13:05:22 GMT

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

Anonymous — Mon, 23 Dec 2019 13:10:33 GMT

WIll try that. Thanks

Anonymous — Mon, 23 Dec 2019 13:40:12 GMT

in the toraclerow i get the same invalid sql statement error