Forum Stats

  • 3,851,398 Users
  • 2,263,971 Discussions
  • 7,904,696 Comments

Discussions

Insert VARCHAR2 into MDSYS.SDO_ORDINATE_ARRAY

961754
961754 Member Posts: 2
edited Sep 13, 2012 7:55AM in SQL & PL/SQL
I 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
Tagged:

Answers

This discussion has been closed.