[Zope] DCoracle 1.3 and NCLOB problem

Andreas Jung ajung@sz-sb.de
Thu, 27 Apr 2000 13:11:03 +0200


Reply-To: 
I have installed DCOracle 1.3 under Solaris 2.7, Python 1.5.2 
and Oracle 8i. I have a testing table:

docnum char(20)
lang  char(2)
fulltext nclob

I am trying to insert some unicode strings into the database.
I have converted them using DCOracle.dbi.dbiRaw(). The insertion
fails with the following error:

Traceback (innermost last):
  File "test.py", line 41, in ?
    curs.execute(com,x=docnum,y=lang,z=raw)
  File "DCOracle/DCOracle/ociCurs.py", line 271, in execute
    r = self._execute(params__, kw)
  File "DCOracle/DCOracle/ociCurs.py", line 232, in _execute
    if rc!=3129: self._error()
  File "DCOracle/DCOracle/ociCurs.py", line 83, in _error
    raise error, (rc, oci_.OracleErrorMessage(self._c.lda, rc))
oci.error: (12704, 'ORA-12704: character set mismatch\012')

I could not find out yet if it's a DCOracle related problem (in
combination with Oracle 8i) or if it is a configuration problem
of my environment.

Thanks for any hint or idea,
Andreas