This discussion is archived
1 Reply Latest reply: Apr 23, 2012 8:50 AM by odie_63 RSS

Problem with over 4k XMLType

767526 Newbie
Currently Being Moderated
Hi,

I try to insert into table with a column type of XMLType a big XML String over 4K using java code.
and get the following ORA error :

ORA-01461: can bind a LONG value only for insert into a LONG column


My table definishion is :

CREATE TABLE TESTTABLE(
id NUMBER(22),
XMLVAL XMLTYPE
)
XMLType COLUMN XMLVAL
STORE AS CLOB (
TABLESPACE data01
STORAGE (INITIAL 100k NEXT 5k )
CHUNK 4096 NOCACHE LOGGING

);

my insert query is :

INSERT INTO TESTTABLE values (1 , XMLType(?))

I am already using OJBC6 jar (mean oracle driver for 11G) and my database is 11G as well.

Any suggestions for a workaround ?

10x

Edited by: Reem on Apr 23, 2012 8:22 AM

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points