How to use DCOracle and LOBs in Oracle 8i ????

Andreas Jung ajung at
Fri Apr 28 06:48:08 EDT 2000

After reading old postings concerning DCOracle and LOBs I
can not solve the following problem:

I have  a table under Oracle 8i with a NCLOB field. The base
character set for the complete database it UTF8. My first
problem with DCOracle was an ORA-12704 character set mismatch error when
I tried to insert an instance of DCOracle.dbi.dbiRaw() in to the database.

My current code looks like this (the table contains the NCLOB field 'content'):

lob = 'very long text .....'
raw = DCOracle.dbi.dbiRaw(lob)

com = 'insert into tab (docnum,content) values(:x,translate(:y using nchar_cs))'

This works for LOBs with less than 4000 bytes. For longer LOBs I get the following error
message: ORA-01461 can bind a LONG value only for insert into a LONG column. can I store larger LOBs with more than 4000 bytes ? I have read something
about a dbms_lob package but I have really no idea how to use it. 

Has anyone a working solution or a code example ?!

Thanks a lot for any hint,

More information about the Python-list mailing list