insert a well known binary object (WKB)

--===============0341152454771941889==
Content-Type: multipart/alternative; boundary="00000000000008286605a9567f19"

--00000000000008286605a9567f19
Content-Type: text/plain; charset="UTF-8"

Hello All,

I have a WKB that I'm trying to insert into a SDO_GEOMETRY column.
Something like this:

cursor.execute("""
    insert into SURVEY(OBJECTID,SURVEY,SHAPE)
    values (:objectid, :survey, SDO_UTIL.FROM_WKBGEOMETRY(:wkb))""",
    objectid=objectid, survey='H13195', wkb=wkb
)

However, I keep getting the error:

cx_Oracle.DatabaseError: ORA-01461: can bind a LONG value only for insert
into a LONG column


Can someone please point me in the right direction?

Thanks!

--john

--00000000000008286605a9567f19
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div class=3D"gmail_default" style=3D"font-size:small">Hel=
lo All,</div><div class=3D"gmail_default" style=3D"font-size:small"><br></d=
iv><div class=3D"gmail_default" style=3D"font-size:small">I have a WKB that=
 I&#39;m trying to insert into a SDO_GEOMETRY column.=C2=A0 Something like =
this:</div><div class=3D"gmail_default" style=3D"font-size:small"><br></div=
><div class=3D"gmail_default" style=3D"font-size:small">cursor.execute(&quo=
t;&quot;&quot;<br>=C2=A0 =C2=A0 insert into SURVEY(OBJECTID,SURVEY,SHAPE)<b=
r>=C2=A0 =C2=A0 values (:objectid, :survey, SDO_UTIL.FROM_WKBGEOMETRY(:wkb)=
)&quot;&quot;&quot;,<br>=C2=A0 =C2=A0 objectid=3Dobjectid, survey=3D&#39;H1=
3195&#39;, wkb=3Dwkb</div><div class=3D"gmail_default" style=3D"font-size:s=
mall">)<br></div><div class=3D"gmail_default" style=3D"font-size:small"><br=
></div><div class=3D"gmail_default" style=3D"font-size:small">However, I ke=
ep getting the error:</div><div class=3D"gmail_default" style=3D"font-size:=
small"><br></div><div class=3D"gmail_default" style=3D"font-size:small">cx_=
Oracle.DatabaseError: ORA-01461: can bind a LONG value only for insert into=
 a LONG column<br></div><div class=3D"gmail_default" style=3D"font-size:sma=
ll"><br></div><div class=3D"gmail_default" style=3D"font-size:small"><br></=
div><div class=3D"gmail_default" style=3D"font-size:small">Can someone plea=
se point me in the right direction?</div><div class=3D"gmail_default" style=
=3D"font-size:small"><br></div><div class=3D"gmail_default" style=3D"font-s=
ize:small">Thanks!</div><div class=3D"gmail_default" style=3D"font-size:sma=
ll"><br></div><div class=3D"gmail_default" style=3D"font-size:small">--john=
</div><div class=3D"gmail_default" style=3D"font-size:small"><br></div></di=
v>

--00000000000008286605a9567f19--


--===============0341152454771941889==
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline


--===============0341152454771941889==
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

_______________________________________________
cx-oracle-users mailing list
cx-oracle-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org
https://lists.sourceforge.net/lists/listinfo/cx-oracle-users

--===============0341152454771941889==--