Datapatch errors with "ORA-22308: operation not allowed on evolved type"
(Doc ID 2907253.1)
Last updated on JULY 20, 2024
Applies to:
Oracle Spatial and Graph - Version 19.4.0.0.0 and laterInformation in this document applies to any platform.
Symptoms
After installing RU 19.17.0.0.0, while executing datapatch following errors are seen in logs
sqlpatch_invocation.log
logfile: <ORACLE_BASE>/cfgtoollogs/sqlpatch/31771877/23869227/31771877_rollback_<SID>_2022Oct31_10_52_38.log (errors)
-> Error at line 109127: script md/admin/catmdloc.sql
- ORA-22308: operation not allowed on evolved type
- ORA-06512: at line 12
- ORA-06512: at line 4
-> Error at line 127276: script md/admin/catmdloc.sql
- ORA-22308: operation not allowed on evolved type
- ORA-06512: at line 32
- ORA-06512: at line 6
31771877_<rollback_SID>_2022Oct31_10_52_38.log
SQL> declare
2 begin
3 begin
4 execute immediate
5 'CREATE OR REPLACE TYPE SDO_GEOMETRY_ARRAY
6 TIMESTAMP ''2008-11-18:10:54:01''
7 OID ''5BF8B4041C603EAEE040578CB2051995''
8 AS VARRAY(10485760) OF MDSYS.SDO_GEOMETRY ';
9 exception
10 when others then
11 SYS.DBMS_SYSTEM.KSDWRT(SYS.DBMS_SYSTEM.TRACE_FILE,
12 'EXCEPTION[sdotypes.sql(' || $$PLSQL_LINE || ')65]: ' || SQLERRM); RAISE;
13 end;
14 begin
15 execute immediate
16 ' create or replace public synonym SDO_GEOMETRY_ARRAY for
17 MDSYS.SDO_GEOMETRY_ARRAY';
18 end;
19 end;
20 /
declare
*
ERROR at line 1:
ORA-22308: operation not allowed on evolved type
ORA-06512: at line 12
ORA-06512: at line 4
Changes
Installed 19.17 RU
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |