Creating a materialized view in 23ai FREE on a remote table in 19c fails with error
ERROR at line 1:
ORA-06550: line 1, column 10:
PLS-00306: wrong number or types of arguments in call to 'GET_LOB_COLUMNS_INFO'
ORA-06550: line 1, column 10:
PL/SQL: Statement ignored
Setup:
In 19c source database:
SQL> create table base(i number(11), dt date default sysdate);
Table created.
SQL> alter table base add constraint base_pk primary key (i);
Table altered.
In 23ai FREE database (database link REMOTE links to the above 19c database):
SQL> desc base@REMOTE;
Name Null? Type
----------------------------------------- -------- ----------------------------
I NOT NULL NUMBER(11)
DT DATE
SQL> alter session set sql_trace=true;
Session altered.
SQL> create materialized view base_mv refresh complete as select * from base@REMOTE;
create materialized view base_mv refresh complete as select * from base@REMOTE
*
ERROR at line 1:
ORA-06550: line 1, column 10:
PLS-00306: wrong number or types of arguments in call to 'GET_LOB_COLUMNS_INFO'
ORA-06550: line 1, column 10:
PL/SQL: Statement ignored
23ai trace file contains:
PARSING IN CURSOR #140596658622736 len=154 dep=1 uid=136 oct=47 lid=136 tim=30838581139564 hv=237780149 ad='88732ee0' sqlid='567b69n72sg5p'
begin sys.dbms_snapshot_utl.get_lob_columns_info@"REMOTE"( :masown, :masnam, :snapcols, :lobcnt, :lobcols, :lobpos, :lobvec, :is_lob_flag); end;
END OF STMT
PARSE #140596658622736:c=511,e=511,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=1,plh=0,tim=30838581139564
EXEC #140596655276376:c=326291,e=633413,p=78,cr=2485,cu=192,mis=0,r=0,dep=0,og=1,plh=0,tim=30838581156628
ERROR #140596655276376:err=6550 tim=30838581156679
Unfortunately, the 19c version of sys.dbms_snapshot_utl being called doesn't match that definition:
PROCEDURE GET_LOB_COLUMNS_INFO
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
MASOWN VARCHAR2 IN
MASNAM VARCHAR2 IN
SNAPCOLS VARCHAR2 IN
LOBCNT NUMBER OUT
LOBCOLS VARCHAR2 OUT
LOBPOSITIONS VARCHAR2 OUT
LOBVECMASK RAW OUT
The 23ai version has gained an extra parameter:
PROCEDURE GET_LOB_COLUMNS_INFO
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
MASOWN VARCHAR2 IN
MASNAM VARCHAR2 IN
SNAPCOLS CLOB IN
LOBCNT NUMBER OUT
LOBCOLS CLOB OUT
LOBPOSITIONS VARCHAR2 OUT
LOBVECMASK RAW OUT
IS_LOB_FLAG BINARY_INTEGER IN DEFAULT
Net result - I can't use materialized views to pull data from 19c into 23ai.
Is this a bug, or am I missing something?