Execute exec statement before query (ToracleInput)

Highlighted
One Star

Execute exec statement before query (ToracleInput)

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

Forteen Stars

Re: Execute exec statement before query (ToracleInput)

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

 

Manohar B
Don't forget to give kudos/accept the solution when a replay is helpful.
One Star

Re: Execute exec statement before query (ToracleInput)

WIll try that. Thanks
One Star

Re: Execute exec statement before query (ToracleInput)

in the toraclerow i get the same invalid sql statement error

2019 GARTNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog

Put Massive Amounts of Data to Work

Learn how to make your data more available, reduce costs and cut your build time

Watch Now

How OTTO Utilizes Big Data to Deliver Personalized Experiences

Read about OTTO's experiences with Big Data and Personalized Experiences

Blog