You should be contacting Oracle about this. Apparently there was a bug in the Oracle10g R2 when freeing temporary LOB's, which affects XMLTYPE functionality. This will be fixed in Oracle11.

However, Oracle has provided a workaround, and we have successfully tested this last week. If you let me know your Delphi version, I can provide you with a pre-release of this workaround.

Hi Marco,

We are using the following versions:

Borland Delphi Enterprise 7.0 (build 8.1)
DOA 4.0.7.1
Oracle 10.2.0.1.0

If it is compatible, can you send us the pre-release of this workaround that you have tested?

Best Regards.

Okay. I will upload it today or tomorrow, and will notify you.

Hi Marco,

We have this same issue and it is severely limiting our ability to support our clients. We are using Delphi 7.0 Enterprise build 4.4, DOA 4.0.7.1 and Oracle 10.2.0.2.0. Can we have a pre-release as well?

Regards,
Alex

Please send me an e-mail with this request.

Hi Marco,

We have tested the workaround but TOracledataset reported errors still remain.

Is there any chance to focus Allround team effort to solve this issue or provide a new workaround?

Best Regards,
Rodrigo.

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, ...