Home » Server Options » Spatial » Update query (windows xp)
Update query [message #500049] 
Thu, 17 March 2011 07:05 

swapnabpnn
Messages: 96 Registered: December 2010

Member 


Hi All,
I am trying to run following query,but t is throwing error.Please correct it as soon as possible.
SQL> update b$gc_cbl_t_temp a set A.G3E_GEOMETRY.sdo_elem_info = sdo_elem_info_a
rray(1,1,1,4,1,0),
2 A.G3E_GEOMETRY.sdo_ordinates(1) = A.G3E_GEOMETRY.SDO_POINT.X,
3 A.G3E_GEOMETRY.sdo_ordinates(2) = A.G3E_GEOMETRY.SDO_POINT.Y,
4 A.G3E_GEOMETRY.sdo_ordinates(3) = 0,
5 A.G3E_GEOMETRY.sdo_ordinates(4) = COS(ORIENTATION_TEMP),
6 A.G3E_GEOMETRY.sdo_ordinates(5) = SIN(ORIENTATION_TEMP),
7 A.G3E_GEOMETRY.sdo_ordinates(6) = 0,
8 A.G3E_GEOMETRY.SDO_POINT = NULL ;
A.G3E_GEOMETRY.sdo_ordinates(1) = A.G3E_GEOMETRY.SDO_POINT.X,
*
ERROR at line 2:
ORA00927: missing equal sign
Thanks.........



Re: Update query [message #500346 is a reply to message #500049] 
Sat, 19 March 2011 15:09 

Barbara Boehmer
Messages: 8586 Registered: November 2002 Location: California, USA

Senior Member 


update b$gc_cbl_t_temp a
set A.G3E_GEOMETRY.sdo_elem_info = sdo_elem_info_array(1,1,1,4,1,0),
A.G3E_GEOMETRY.sdo_ordinates =
sdo_ordinate_array
(A.G3E_GEOMETRY.SDO_POINT.X,
A.G3E_GEOMETRY.SDO_POINT.Y,
0,
COS(ORIENTATION_TEMP),
SIN(ORIENTATION_TEMP),
0),
A.G3E_GEOMETRY.SDO_POINT = NULL;





Goto Forum:
Current Time: Tue Sep 27 10:39:10 CDT 2016
Total time taken to generate the page: 0.17812 seconds
