[Zope] LONG insert > 2000 chars fail

Riku Voipio Riku.Voipio@tietoenator.com
Thu, 6 Jul 2000 15:06:37 +0300


Hi, 

Looks like DCOracle/Zoracle still doesn't support LONG objects properly.
According to Oracle's overly verbose "SERVER MESSAGES" manual the 
following means that oracle will accept only upto 2000 chars as 
quoted string, anything more should be uploaded via binded variables...

Error Type: oci.error
Error Value: (1704, 'ORA-01704: string literal too long')


 Traceback (innermost last):
  File /usr/lib/zope/lib/python/ZPublisher/Publish.py, line 214, in publish_module
  File /usr/lib/zope/lib/python/ZPublisher/Publish.py, line 179, in publish
  File /usr/lib/zope/lib/python/Zope/__init__.py, line 202, in zpublisher_exception_hook
    (Object: ElementWithAttributes)
  File /usr/lib/zope/lib/python/ZPublisher/Publish.py, line 165, in publish
  File /usr/lib/zope/lib/python/ZPublisher/mapply.py, line 160, in mapply
    (Object: insert_reporter)
  File /usr/lib/zope/lib/python/ZPublisher/Publish.py, line 102, in call_object
    (Object: insert_reporter)
  File /usr/lib/zope/lib/python/OFS/DTMLDocument.py, line 166, in __call__
    (Object: insert_reporter)
  File /usr/lib/zope/lib/python/DocumentTemplate/DT_String.py, line 504, in __call__
    (Object: insert_reporter)
  File /usr/lib/zope/lib/python/DocumentTemplate/DT_Util.py, line 335, in eval
    (Object: insert_report(app=app,tmodule=tmodule,ver=ver,header=header,text=text, tyyppi=TYYPPI))
    (Info: header)
  File <string>, line 0, in ?
  File /usr/lib/zope/lib/python/Shared/DC/ZRDB/DA.py, line 430, in __call__
    (Object: insert_report)
  File /usr/lib/zope/lib/python/Products/ZOracleDA/db.py, line 189, in query
  File /usr/lib/zope/lib/python/Products/ZOracleDA/DCOracle/ociCurs.py, line 298, in execute
  File /usr/lib/zope/lib/python/Products/ZOracleDA/DCOracle/ociCurs.py, line 221, in _parse
  File /usr/lib/zope/lib/python/Products/ZOracleDA/DCOracle/ociCurs.py, line 109, in _error
oci.error: (see above)

--
Riku Voipio
riku.voipio@tietoenator.com
09-862 60764