Hello,
when I try to select from a table with a column of sys.xmltype ("select * from
c041_dev.xmltest") I get the following error message:
DBD::Oracle::db prepare failed: ORA-22318: input type is not an array type (DBD
ERROR: OCIAttrGet) [for Statement "select * from C041_DEV.XMLTEST"] at [...].
Can someone please tell me what I have to do to get the statement executed?
I am using Activestate perl 5.10.0, DBI 1.607 and DBD::Oracle 1.21 on Windows
XP.
The release of the oracle database server is 9.2.0.8.0 and the client is
10.2.0.1.0.
The table create statement is:
create table c041_dev.xmltest
(
id integer primary key,
xml sys.xmltype
);
insert into c041_dev.xmltest values(0, '<root/>');
Servus -- Alfred
--
Alfred Mickautsch
SCHULER Business Solutions AG
Karl-Berner-Str. 4
72285 Pfalzgrafenweiler
Deutschland
Tel: +49 7445 830-184
Fax: +49 7445 830-349
E-Mail: [EMAIL PROTECTED]
Web: www.schuler-ag.com
SCHULER Business Solutions AG
Aktiengesellschaft mit Sitz in D-72285 Pfalzgrafenweiler, Karl-Berner-Str. 4
Registergericht Stuttgart HRB 430947
Vorstand: Uwe Jonas, Harald Sieber
Vorsitzender des Aufsichtsrates: Achim Gauß
