| Subject: | Fails to "select ... from" with an MDSYS.XMLTYPE column |
Encountered when I tried to use DBIx::Class::Schema::Loader. At some
point, it encounters the sdo_coord_op_param_vals table, which looks like
this in sqlplus:
Show quoted text
SQL> describe sdo_coord_op_param_vals
Name Null? Type
----------------------------------------- --------
----------------------------
COORD_OP_ID NOT NULL NUMBER(10)
COORD_OP_METHOD_ID NUMBER(10)
PARAMETER_ID NOT NULL NUMBER(10)
PARAMETER_VALUE FLOAT(49)
PARAM_VALUE_FILE_REF VARCHAR2(254)
PARAM_VALUE_FILE CLOB
PARAM_VALUE_XML MDSYS.XMLTYPE
UOM_ID NUMBER(10)
DBD::Oracle fails like this:
$ perl -MDBI -wle '$dbh=DBI->connect("dbi:Oracle:host=localhost;sid=xe",
"login", "password") or die; $d->do("select * from
sdo_coord_op_param_vals")'
DBD::Oracle::db do failed: ORA-22318: input type is not an array type
(DBD ERROR: OCIAttrGet) [for Statement "select * from
sdo_coord_op_param_vals"] at -e line 1.