[Zope] Inserting LONGs with DCOracle

Peter Sabaini sabaini@niil.at
Mon, 20 Nov 2000 10:19:43 +0100 (CET)


do something like:

from DCOracle import *
conn=Connect( "%s/%s@%s" % (user,pw,srv) )
h=conn.prepare("insert into table_x (x,y,z) values :p1, p2:, :p3")
long_str = 'a'*8000
h.execute(1,2,long_str)

assuming column z is declared as LONG

hth

peter.


On Fri, 17 Nov 2000, Dorothea Kuehn wrote:

:Hi,
:If I try to insert an ca.5000 char string with DCOracle(1.3.2) into a LONG
:column in Oracle (8i) I keep getting ORA-1704 'string literal too
:long'-Errors.
:
:Ok, I read here
:http://osi.oracle.com/~tkyte/Misc/LargeStrings.html
:that it will work (a) with bind variables or (b) that I have to use
:ODBC,OCI or alike.
:
:Questions: (a) Can I use bind variables with DCOracle? How?
:(b) I thought DCOracle is using OCI, so why the heck this isn't working?
:Any workarounds?
:
:thanks for help,
:dekay
:
:_______________________________________________
:Zope maillist  -  Zope@zope.org
:http://lists.zope.org/mailman/listinfo/zope
:**   No cross posts or HTML encoding!  **
:(Related lists -
: http://lists.zope.org/mailman/listinfo/zope-announce
: http://lists.zope.org/mailman/listinfo/zope-dev )
:

-- 

_________________________________________________
peter sabaini, mailto: sabaini@niil.at
-------------------------------------------------