Using Oracle WKB Data with Spotfire Map Chart drawing circle is failed

1 、create table to save geometry date:

CREATE TABLE  Maps3(

    StateID NUMBER(18,0) NOT NULL,

    StateName VARCHAR2(256 BYTE) NOT NULL, 

     geometry BLOB

2、insert line or rectangle can show in Spotfire,but insert circle and cpmpound Line string can not show。operation is followed:

 INSERT INTO GEO_CICLE(Id,Name,geo) VALUES(1,'line', MDSYS.SDO_GEOMETRY( 2002,  NULL,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,2,1), MDSYS.SDO_ORDINATE_ARRAY(4,10, 6,11) ).get_wkb());

INSERT INTO GEO_CICLE(Id,Name,geo)  VALUES (15,'Circle',sdo_geometry (2003, null, null, sdo_elem_info_array (1,1003,4), sdo_ordinate_array (15,145, 10,150, 20,150)).get_wkb());

INSERT INTO GEO_CICLE(Id,Name,geo)  VALUES(4,'mul_line', MDSYS.SDO_GEOMETRY( 2002,  NULL,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,4,2, 1,2,1, 3,2,2), MDSYS.SDO_ORDINATE_ARRAY(10,10, 10,14, 6,10, 14,10) ).get_wkb());

Attachments

AttachmentSize
Image icon question.jpg46.11 KB

(1) Answer

Login