Home » Server Options » Spatial » Update query (windows xp)
Update query [message #500049] Thu, 17 March 2011 07:05 Go to next message
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:
ORA-00927: missing equal sign



Thanks.........
Re: Update query [message #500346 is a reply to message #500049] Sat, 19 March 2011 15:09 Go to previous messageGo to next message
Barbara Boehmer
Messages: 9077
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;

Re: Update query [message #500408 is a reply to message #500346] Mon, 21 March 2011 00:07 Go to previous messageGo to next message
swapnabpnn
Messages: 96
Registered: December 2010
Member
Thanks a lot.Now query is working fine..
Could you please provide me some links regarding spatial with some examples.. so that I can learn more.
Re: Update query [message #500411 is a reply to message #500408] Mon, 21 March 2011 00:15 Go to previous message
Barbara Boehmer
Messages: 9077
Registered: November 2002
Location: California, USA
Senior Member
http://download.oracle.com/docs/cd/E11882_01/appdev.112/e11830/toc.htm
Previous Topic: Address parsing using SDO_GCDR?
Next Topic: query only ONE SDO_ORDINATE
Goto Forum:
  


Current Time: Thu Mar 28 12:45:26 CDT 2024