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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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,942 views