Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ?