View Issue Details

Jump to NotesJump to History
IDProjectCategoryView StatusDate SubmittedLast Update
0003135SymmetricDSBugpublic2017-06-02 10:072025-02-26 18:59
Reporterjacobking Assigned To 
Priorityhigh 
Status closedResolutionwon't fix 
Product Version3.8.24 
Summary0003135: oracle type of MDSYS.SDO_GEOMETRY is not work
DescriptionI created a table WFS ,has a field type is MDSYS.SDO_GEOMETRY,but when i add data to table An unexpected error ocurred！here it is:

[Err] ORA-04063: package body "MDSYS.SDO_UTIL" has errors
ORA-06508: PL/SQL: could not find program unit being called: "MDSYS.SDO_UTIL"
ORA-06512: at "MDSYS.SDO_GEOMETRY", line 61
ORA-06512: at "SYM_BRANCH01.SYM_WKT2GEOM", line 1
Steps To Reproduce--CREATE TABLE
CREATE TABLE "SYM_MASTER"."WFS" (
"OID" NUMBER NULL ,
"GEOMETRY" "MDSYS"."SDO_GEOMETRY" NULL ,
"ADDR" VARCHAR2(255 BYTE) NULL
)
--Sample Symmetric Configuration

delete from sym_trigger_router;
delete from sym_trigger;
delete from sym_router;
delete from sym_channel where channel_id in ('dlgq_kfq');
delete from sym_node_group_link;
delete from sym_node_group;
delete from sym_node_host;
delete from sym_node_identity;
delete from sym_node_security;
delete from sym_node;


insert into sym_channel
(channel_id, processing_order, max_batch_size, enabled, description)
values('WFS', 1, 100000, 1, 'kfq data from register and back office');



insert into sym_node_group (node_group_id) values ('master');
insert into sym_node_group (node_group_id) values ('branch');

insert into sym_node_group_link (source_node_group_id, target_node_group_id, data_event_action) values ('master', 'branch', 'W');
insert into sym_node_group_link (source_node_group_id, target_node_group_id, data_event_action) values ('branch', 'master', 'P');




insert into sym_trigger
(trigger_id,source_table_name,channel_id,last_update_time,create_time)
values('WFS','WFS','WFS',current_timestamp,current_timestamp);

insert into sym_router(router_id,source_node_group_id,target_node_group_id,router_type,create_time,last_update_time)values('master_2_branch', 'master', 'branch', 'default',current_timestamp, current_timestamp);

insert into sym_router (router_id,source_node_group_id,target_node_group_id,router_type,create_time,last_update_time)values('branch_2_master', 'branch', 'master', 'default',current_timestamp, current_timestamp);


insert into sym_trigger_router
(trigger_id,router_id,initial_load_order,last_update_time,create_time)
values('WFS','branch_2_master', 100, current_timestamp, current_timestamp);

insert into sym_node (node_id,node_group_id,external_id,sync_enabled,sync_url,schema_version,symmetric_version,database_type,database_version,heartbeat_time,timezone_offset,batch_to_send_count,batch_in_error_count,created_at_node_id)
 values ('000','master','000',1,null,null,null,null,null,current_timestamp,null,0,0,'000');
insert into sym_node (node_id,node_group_id,external_id,sync_enabled,sync_url,schema_version,symmetric_version,database_type,database_version,heartbeat_time,timezone_offset,batch_to_send_count,batch_in_error_count,created_at_node_id)
 values ('001','branch','001',1,null,null,null,null,null,current_timestamp,null,0,0,'000');


insert into sym_node_security (node_id,node_password,registration_enabled,registration_time,initial_load_enabled,initial_load_time,created_at_node_id)
 values ('000','5d1c92bbacbe2edb9e1ca5dbb0e481',0,current_timestamp,0,current_timestamp,'000');
insert into sym_node_security (node_id,node_password,registration_enabled,registration_time,initial_load_enabled,initial_load_time,created_at_node_id)
 values ('001','5d1c92bbacbe2edb9e1ca5dbb0e481',1,null,1,null,'000');


insert into sym_node_identity values ('000');


--INIT DATA
INSERT INTO "SYM_MASTER"."WFS" VALUES ('1', MDSYS.SDO_GEOMETRY(2001, null, MDSYS.SDO_POINT_TYPE(113.735570, 22.985180, null), null, null), '5');
Additional InformationTHE ERROR INFO

[SQL]INSERT INTO "WFS" VALUES ('1', MDSYS.SDO_GEOMETRY(2001, null, MDSYS.SDO_POINT_TYPE(113.735570, 22.985180, null), null, null), '5')
[Err] ORA-04063: package body "MDSYS.SDO_UTIL" has errors
ORA-06512: at "SYM_BRANCH01.SYM_ON_I_FOR__BRNCH", line 4
ORA-04088: error during execution of trigger 'SYM_BRANCH01.SYM_ON_I_FOR__BRNCH'
Tagsdata type, dialect: oracle

Activities

jacobking

2017-06-05 10:14

reporter   ~0001052

my oracle version is 11g,while SDO_UTIL.TO_WKTGEOMETRY looks like is 12C's summary，is that the problem？can you support 11g？many thanks!

emiller

2025-02-26 18:59

developer   ~0002645

Oracle 11g is end of life as of 2020.

Issue History

Date Modified Username Field Change
2017-06-02 10:07 jacobking New Issue
2017-06-05 10:14 jacobking Note Added: 0001052
2019-04-24 15:17 elong Tag Attached: data type
2019-04-24 15:17 elong Tag Attached: dialect: oracle
2025-02-26 18:59 emiller Status new => closed
2025-02-26 18:59 emiller Resolution open => won't fix
2025-02-26 18:59 emiller Note Added: 0002645