Skip to Main Content

Oracle Database Express Edition (XE)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-03114 Error when using xmltype.getClobVal() and ROWID

494018Aug 23 2006 — edited Aug 24 2006

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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 21 2006
Added on Aug 23 2006
3 comments
370 views