View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0003135 | SymmetricDS | Bug | public | 2017-06-02 10:07 | 2019-04-24 15:17 |
| Reporter | jacobking | Assigned To | |||
| Priority | high | ||||
| Status | new | Resolution | open | ||
| Product Version | 3.8.24 | ||||
| Summary | 0003135: oracle type of MDSYS.SDO_GEOMETRY is not work | ||||
| Description | I 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 Information | THE 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' | ||||
| Tags | data type, dialect: oracle | ||||