[Zope] How do I use a Z Oracle Connection in a script?

J. Cone jcone@g8labs.com
Mon, 16 Jul 2001 13:51:51 +0100


Hello Dieter,

I think the problem is not quotes.  I suspect it is caused by embedded NUL
characters, because I am attempting to store binary data.

Here are the last few lines from the trace file, and I will try your other
information next.

Thank you,
J. Cone

<assorted deallocation>
* 995287742.487,  17, Cursor_getattr, 0x408a6de8, 0x405f051c ?= prepare, *
* 995287742.488,  18, Cursor_getattr, 0x408a6de8, *
* 995287742.488,  17, Cursor_prepare, 0x408a6de8, 0x408aa7f8, *
* 995287742.488,  33, OCIStmtPrepare, 0x40894568, 0x408b3d9c ?= update
abs_acct_
reference set profile = ', 41, *
* 995287742.488,  34, OCIStmtPrepare, -1, *
* 995287742.488,  36, RaiseOCIError, 1756, 0x407926a8 ?= ORA-01756: quoted
strin
g not properly terminated
, *
* 995287742.489,  17, ServerContext_getattr, 0x40883b50, 0x40476984 ?=
rollback,
 *
* 995287742.489,  18, ServerContext_getattr, 0x408a20b8, *
* 995287742.489,  17, ServerContext_rollback, 0x40883b50, 0x4004caf0, *
* 995287742.489,  33, OCITransRollback, 0, *
* 995287742.490,  34, OCITransRollback, 0, *
* 995287742.491,  17, ServerContext_rollback, *


At 14:12 14/07/01 +0200, Dieter Maurer wrote:
<snip>
>Unprintable characters should not pose problems.
>"dtml-sqlvar ... type=string" properly quotes embedded quotes.
>Thus, it should work!

<other suggestion of traversing global variables snipped>