ORA-21779: duration not active error line 25 of MDSYS.AGGRUNION
I execute the following pl/sql (line 56/57 in
a procedure called RebuildSMZLabels)....
v_query := 'SELECT /*+ INDEX ( A BASE_SMZ_A_SHAPE ) NO_INDEX ( A BASE_SMZ_A_RETIREDATE ) */ MDSYS.SDO_AGGR_UNION(MDSYS.SDOAGGRTYPE(a.s
hape,:1)) FROM &owner.base_smz_a A WHERE MDSYS.SDO_RELATE(a.shape,:2,''mask=ANYINTERACT querytype=window'') = ''TRUE'' and retiredate is
null';
EXECUTE IMMEDIATE v_query INTO v_union_shape USING v_diminfo(1).sdo_tolerance, v_trans_shape ;
And I get...
Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.4.0 - Production
DECLARE
*
ERROR at line 1:
ORA-21779: duration not active
ORA-06512: at "MDSYS.AGGRUNION", line 25
ORA-06512: at "MDSYS.AGGRUNION", line 25
ORA-06512: at line 1
ORA-06512: at "MDCADM.REBUILDSMZLABELS", line 57
ORA-06512: at line 5
Got me beat... anyone got any ideas?
Simon Greener
GIS Manager
Forestry Tasmania