Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Mayot
Contributor III
Contributor III

tOracleRow doesn't work with CALL option "atomic_refresh"

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 ?

Labels (5)
0 Replies