How to read XMLTYPE field from Oracle 10g with LSXLC in Notes 7.0.2

HCL Domino Domino Forum
1

Hi,

I want to read Oracle database data from Notes using LSXLC. My problem is that we have an Oracle field using the XmlType type. When we try select this field, we always get this error:

Error: Invalid data type for field ‘ECIN_FORMLR’, Connector ‘oracle’, Method -Execute-

After few hours on the net searching for informations about this type of field and LSXLC, I was unable to find any documentation. Is there a way to read this type of field in Notes using LSXLC?

Will the solution be to convert the field in Oracle from XmlType to CLOB?

Thanks,

Carl

2

Subject: How to read XMLTYPE field from Oracle 10g with LSXLC in Notes 7.0.2

In your SQL Statement your using(LCconn.exectute) to pull the records add some SQL to convert that field type to a CLOB as stated.

3

Subject: RE: How to read XMLTYPE field from Oracle 10g with LSXLC in Notes 7.0.2

Hello

I worked with Carl on this project and we are now able to use CLOB fields in Oracle and interrogate it with an SQL statement (Select from table) in LSX.

But, if the CLOB field returns a value bigger than 64K, it doesn’t works. It returns only a truncated, incomplete version of the text.

For values smaller than 64K, everything works well, but for values bigger than 64K, no error returned, but a truncated value…

We tried a few things here and nothing worked. Is there a way to obtain CLOB field values bigger than 64K with LSX?