Sorry, I though this was about the XMLTYPE issue. This thread went off-topic halfway, so it's a bit difficult.

The problem with your issue is that Oracle9 reports the column as optional, whereas Oracle10 reports it as required. The only work-around I could find is to use the rowidtochar function for the rowid column in the view. Now it is reported as optional again, and it should work the same on Oracle9 and Oracle10:

create view ... as
select ..., rowidtochar(ROWID) as RID, ...