Advertisement
Guest User

Untitled

a guest
Apr 1st, 2015
180
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.48 KB | None | 0 0
  1. geom_str = '"MDSYS"."SDO_GEOMETRY"(2003,NULL,NULL,"MDSYS"."SDO_ELEM_INFO_ARRAY"(1,1003,1),"MDSYS"."SDO_ORDINATE_ARRAY"(-735342,-1010550,-735347,-1010551,-735347,-1010563,-735342,-1010563,-735342,-1010550))'
  2. insert = u'''INSERT INTO poly_gr (geomtype, sdo_geom ) VALUES ("TARGET"."LIDS_GEOMTYPE"(1002,6) ,%s)''' %geom_str
  3. cur.execute(insert)
  4.  
  5. insert = u'''INSERT INTO poly_gr (geomtype, sdo_geom ) VALUES (:1 ,:2)'''
  6. cur.execute(insert, ('"TARGET"."LIDS_GEOMTYPE"(1002,6)', geom_str)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement