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 -------------------------------------------------