ora-01704 The xmltype field is not long enough to hold the value being inse
399902Dec 3 2003 — edited Dec 7 2003when I insert a value that is to large into the xmltype field of my table I get the following error:
ora-01704 string literal too long
how can I increase the size of an xmltype field so that it can hold atleast 4000 characters.
the following is the script that I use to create the table:
CREATE TABLE FRMD_EVENT_UPDATE01
(
FRMD_TRANS_DATE DATE DEFAULT SYSDATE NOT NULL,
XML_EVENT_UPDATE SYS.XMLTYPE,
FRMD_USER_RECORD_SEQ NUMBER(6),
RECORD_PROCESSED CHAR(1 BYTE)
)
TABLESPACE FRMD_DEFAULT
PCTUSED 40
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 64K
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
FREELISTS 1
FREELIST GROUPS 1
BUFFER_POOL DEFAULT
)
NOLOGGING
NOCACHE
NOPARALLEL;
Please HELP!