problem with xmltype

[ciabalaba]

Does anyone know of any problem with xmltypes?
It seems that pl/sql consider xmltypes as clobs,
and crashes the Oracle instance on call of table like this

create or replace type mex_type as object
( livello_svd varchar2(3),
execution_id number(3),
pkg varchar2(40),
func_proc varchar2(40),
tabella varchar2(40),
mex varchar2(200),
xml_doc xmltype,
data date,
livello number(2)
)

create table DWH_MF2_VERIFICHE
of MF2.MEX_TYPE

if you do a "Query data " on this table you get
select * from DWH_MF2_VERIFICHE

but generates an error on plsql that needs instead
select ..., t.xml_doc.getclobval() aa from DWH_MF2_VERIFICHE t

Did anybody have any problem like this?
maybe we need some recent oci's??
Thank you
riccardo

 

[Marco Kalter]

It works okay for me, but we have had some more reports about xmltype issues. It is most likely related to a specific client/server/platform version.