tOracleRow doesn't work with CALL option "atomic_refresh"

Mayot — Sat, 16 Nov 2024 01:24:51 GMT

Hello,

I want to use tDBRow (Oracle) to refresh a materialized view using this expression :

CALL DBMS_MVIEW.REFRESH('MV_NAME', method => '?', atomic_refresh => FALSE)

This work great in SQL Developer 19.4

But in tDBRow this doesn't work.

I get the following error : java.sql.SQLException: ORA-06576 : not a valid function or procedure name

It work if I remove the atomic_refresh (that is not what i want) or if i use another synthax (work like i want) :

BEGIN

DBMS_MVIEW.REFRESH( 'MV_NAME', method => '?', atomic_refresh => FALSE);

END;

So why the tOracleRow doesn't work with the "atomic_refresh" option ?

topic tOracleRow doesn't work with CALL option "atomic_refresh" in Talend Studio