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