Insert XMLTYPE in Oracle 9i

From: a_hariram <member30432_at_dbforums.com>
Date: Thu, 29 May 2003 19:34:36 +0000
Message-ID: <2936906.1054236876_at_dbforums.com>


How should I insert XMLTYPE data in Oracle9i.

I used the following insert statement in Oracle 9i in Unix OS

INSERT INTO str_dta
VALUES (3569,405,0,XMLTYPE('<ASE>50</ASE>'));

I got the following error

ORA-31011: XML parsing failed
ORA-06512: at "SYS.XMLTYPE", line 0
ORA-06512: at line 1

Can anyone help me know how to insert records in SQLPLUS using insert statements for records of the above type.

Structure of str_dta is
SNo number(5)
EmpNo number(4)
Status number(1)
Details SYS.XMLTYPE

Should I set any environment variable before doing the above insert?

--
Posted via http://dbforums.com
Received on Thu May 29 2003 - 21:34:36 CEST

Original text of this message