[DB-SIG] oracledb and LONG

Geir Ove Gronmo grove@infotek.no
Thu, 17 Sep 1998 09:05:53 +0200

At 14:27 16.09.98 -0400, Lixin Zhou wrote:
>How can I pull out the value of a LONG field using oracledb?  What
>returns by cursor.fetchone or cursor.fetchall is always an empty
>string (not None).

I've got the opposite problem. How can I insert a string or the content of
a file (longer than 10Kb) into a LONG RAW field in the database using the
oracledb module (0.1.3)? I've tried to use an ordinary insert statement --
and hexencoding the string, but I get an error message back from Oracle
(ORA-1704 "string literal to long") when the document it longer than about
2000 characters.

Could someone please help me out with this?

All the best,
Geir O.

 ==================  Geir Ove Grønmo  ==================
|  STEP Infotek as, Gjerdrumsvei 12, 0486 Oslo, Norway  |
|        grove@infotek.no http://www.infotek.no/        |