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>
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.comReceived on Thu May 29 2003 - 21:34:36 CEST