Skip to Main Content

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

insert a row

don123Dec 30 2016 — edited Mar 31 2017

table test has following structure.

test (id number, geom mdsys.sdo_geometry)

I am able to insert a row with below sql. It works fine.

insert into test values (10, SDO_UTIL.FROM_WKTGEOMETRY(('POLYGON ((4 5, 6 7, 9 7, 4 5))')));

How to write the above sql statement in python and cx_Oracle.

I want to use variable as below.

x = POLYGON ((4 5, 6 7, 9 7, 4 5))

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 28 2017
Added on Dec 30 2016
12 comments
1,946 views