Re: [cx-oracle-users] Trying to copy the value of a SDO_GEOMETRY column from one table to another

[Anthony T. <ant...@gm...>]

Hi Michael,

Jani is right in that cx_Oracle currently does not support binding
objects....but I am working on changing that and hope to have that
capability implemented soon. :-) I'll reply back again when that is done
but if you need it immediately you'll have to follow the workaround Jani
suggested.

Anthony

On Mon, Feb 8, 2016 at 2:33 AM, Jani Tiainen <re...@gm...> wrote:

> Hi,
>
> Unfortunately cx_Oracle doesn't support writing user types to database,
> only reading.
>
> There are few options to overcome your problem:
>
> Make output as varchar/clob like wkt. This is relatively slow.
>
> Another option is to use nice approach described here:
> http://www.tolon.co.uk/2012/09/geometry-objects-across-dblink/
>
>
>
> On 07.02.2016 16:13, Michael Huber wrote:
>
> Hi,
>
> I'm querying from a table with a SDO_GEOMETRY column and want to store the
> content of this column to another table. If I do so, I'm receiving the
> following exception:
>
> cx_Oracle.NotSupportedError: Variable_TypeByValue(): unhandled data type
> cx_Oracle.OBJECT
>
> Please find a basic example below:
>
> Python 3.5.1 (default, Jan 20 2016, 15:13:56)
> [GCC 4.8.5 20150623 (Red Hat 4.8.5-4)] on linux
> Type "help", "copyright", "credits" or "license" for more information.
> >>> import cx_Oracle
> >>> con = cx_Oracle.connect('user1/pass1@hostname:1521/TESTDB')
> >>> cur = con.cursor()
> >>>
> >>> cur.execute("SELECT * FROM USER1.SOURCE_TABLE WHERE id = 1")
> <cx_Oracle.Cursor on <cx_Oracle.Connection to user1@hostname:1521/TESTDB>>
> >>> source_data = cur.fetchall()
> >>>
> >>> print(source_data)
> [(1, 'testvalue', <cx_Oracle.OBJECT object at 0x7f39e2561c70>)]
> >>>
> >>> cur.execute("INSERT INTO USER1.TARGET_TABLE VALUES (:1, :2, :3 )",
> [source_data[0][0], source_data[0][1], source_data[0][2] ])
> Traceback (most recent call last):
>   File "<stdin>", line 1, in <module>
> cx_Oracle.NotSupportedError: Variable_TypeByValue(): unhandled data type
> cx_Oracle.OBJECT
> >>>
>
> Is it not supported to write the content of a SDO_GEOMETRY column back to
> an Oracle database? Thanks in advance!
>
> Best,
> Micheal
>
>
> ------------------------------------------------------------------------------
> Site24x7 APM Insight: Get Deep Visibility into Application Performance
> APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
> Monitor end-to-end web transactions and take corrective actions now
> Troubleshoot faster and improve end-user experience. Signup Now!http://pubads.g.doubleclick.net/gampad/clk?id=272487151&iu=/4140
>
>
>
> _______________________________________________
> cx-oracle-users mailing lis...@li...https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>
>
> --
> Jani Tiainen
>
>
> ------------------------------------------------------------------------------
> Site24x7 APM Insight: Get Deep Visibility into Application Performance
> APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
> Monitor end-to-end web transactions and take corrective actions now
> Troubleshoot faster and improve end-user experience. Signup Now!
> http://pubads.g.doubleclick.net/gampad/clk?id=272487151&iu=/4140
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>
>