This content has been marked as final. Show 4 replies
thanks...but i could'nt understteand it. do you know how can i set the array so it can read more than 999?
quoted from siva ( host variable using the SDO_GEOMETRY constructor )
For example, this PL/SQL block:
varr := sdo_ordinate_array();
FOR idx in 1 .. no_of_ordinates LOOP
varr(idx) := val_i;
Then in the insert statement:
'insert into testTable value (sdo_geometry(gtype, srid, null, sdo_elem_info_array(....), :varr) '
which part to insert the coordinates??? could you pls tell me? thanks..
The for loop is the place where you set
your ordinates into the ordinate array "varr" and then the insert statement
(via execute immediate) uses that variable via binding to insert the coordinates.
Siva explained it in the thread that i refered you to.