Problem Updating field with a CLOB datatype

[borisch]

I am trying to rur SQL statement to update one field with a datatype "clob" and SQL give me an error "ORA-01704: string literal too long ".
The len of the string I am trying to save is 8336 chr. It could be longer or shorter depending on a webpage.
If I take only 4000 chr left(XHTML,4000) then everything is fine. I thought that CLOB take 4GB of text. What am I doing wrong? Please help.

I have a table like this:
CREATE TABLE SMKT.INT_SESSIONLOG1
(
LOGID VARCHAR2(50) NULL,
SESSIONID VARCHAR2(50) NULL,
DATECREATED VARCHAR2(50) NULL,
PAGEXML CLOB NULL,
XHTML CLOB NULL,
USERID VARCHAR2(50) NULL
)

and

update statement like this:

Update INT_SESSIONLOG SET XHTML = '" & mXHTML.xml "' WHERE LogID = '" & msLogID & "'"

Thanks a lot.

 

[spenglerr]

Hi,

actually the information is not enough to answer the question.

1) Which client is used or from which application are you running the SQL statement?

2) Is this running in an PL/SQL-Block/Procedure or as a normal SQL-statement?

3) Can the data size exceed 32k?