[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

Inserting into Oracle CLOBS

Hi Everyone,

I'm trying to do an insert of a lengthy string into an Oracle 8i CLOB column
(character LOB). I've inserted it successfully into a LONG column before but
when I try to insert it into a CLOB instead I get the error:

ORA-03113: end-of-file on communication channel
(SQR 5528) ORACLE OROL error -1041 in cursor 0:
   ORA-01041: internal error. hostdef extension doesn't exist

This error only occurs for strings over around 4000 bytes (even though the
CLOB storage is set to not inline).

Has anyone else had this problem?

Jill





_________________________________________________________________
Chat with friends online, try MSN Messenger: http://messenger.msn.com