Hi All,
<br><br>
I bumped into an ORA-03114 error, with an associated core dump, in Oracle XE on Windows XP while doing something similar to the following test case. If anyone knows of a patch or workaround I'd appreciate hearing about it.
create table bug_table ( col xmltype );
insert into bug_table values ( xmltype( '<test>test value</test>' ) ) ;
-- this works
select rowid
from ( select bt.col as col2 from bug_table bt )
;
ROWID
------------------
AAAQs8AAEAAADm3AAA
-- this does not
select rowid
from ( select bt.col.getClobVal() as col2 from bug_table bt );
select rowid
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel