ORA-30373: when using: DBMS_REPCAT_RGT.INSTANTIATE_OFFLINE
edited Mar 10, 2010 1:58AM in GoldenGate, Streams and Distributed Database (MOSC) 1 commentAnswered ✓
Hello Adv Rep Community
I was wondering if anyone has had experience with Updatable Mviews based on a table that contains a column of type
MDSYS.SDO_GEOMETRY. I have a simple object that when I use the offline instantiation I get.
SQL> SET SERVEROUTPUT ON
SQL> DECLARE
2 dt_num NUMBER;
3 BEGIN
4 dt_num := DBMS_REPCAT_RGT.INSTANTIATE_OFFLINE(
5 refresh_template_name => 'DT_SHAPE',
6 user_name => 'RK_MVIEW',
7 site_name => 'rkdb2.world',
8 next_date => sysdate,
9 interval => 'sysdate + (1/144)');
10 DBMS_OUTPUT.PUT_LINE('Template ID = ' || dt_num);
11 END;
12 /
DECLARE
*
ERROR at line 1:
ORA-30373: object data types are not supported in this context
I was wondering if anyone has had experience with Updatable Mviews based on a table that contains a column of type
MDSYS.SDO_GEOMETRY. I have a simple object that when I use the offline instantiation I get.
SQL> SET SERVEROUTPUT ON
SQL> DECLARE
2 dt_num NUMBER;
3 BEGIN
4 dt_num := DBMS_REPCAT_RGT.INSTANTIATE_OFFLINE(
5 refresh_template_name => 'DT_SHAPE',
6 user_name => 'RK_MVIEW',
7 site_name => 'rkdb2.world',
8 next_date => sysdate,
9 interval => 'sysdate + (1/144)');
10 DBMS_OUTPUT.PUT_LINE('Template ID = ' || dt_num);
11 END;
12 /
DECLARE
*
ERROR at line 1:
ORA-30373: object data types are not supported in this context
0