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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
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