Insert VARCHAR2 into MDSYS.SDO_ORDINATE_ARRAY
961754Sep 12 2012 — edited Sep 13 2012I am attempting to pass a variable to a MDSYS.SDO_ORDINATE_ARRAY can hard code the value but cannot pass in the variable. UDT does not accept char strings.
value for insert MDSYS.SDO_GEOMETRY(2002, 8307, null,MDSYS.SDO_ELEM_INFO_ARRAY(1, 1003, 1),MDSYS.SDO_ORDINATE_ARRAY( ))
if I hard code
MDSYS.SDO_GEOMETRY(2002, 8307, null,MDSYS.SDO_ELEM_INFO_ARRAY(1, 1003, 1),MDSYS.SDO_ORDINATE_ARRAY(0,0, 10,0, 10,10, 0,10, 0,0, 4,4, 6,4, 6,6, 4,6, 4,4 ))
works
input variable
,p_linear_ring IN VARCHAR2
is passed from another application so p_linear_ring is not in a table using a select statment is not possible
will look like
p_linear_ring := '0,0, 10,0, 10,10, 0,10, 0,0, 4,4, 6,4, 6,6, 4,6, 4,4 '
Loading many different combination of p_linear_ring
Edited by: 958751 on Sep 12, 2012 11:19 AM