Synametrics Technologies

When doing a SQL select on an Oracle table containing a column of XMLType, the following error is returned. Reconnection to the database is then necessary as the query appears to run on indefinately and can not be stopped by pressing the stop button: Access violation at address 04C0F368 in module 'SQORA32.DLL'. Write of address 01A4F000. or, sometimes, Access violation at address 0180C3F6 in module 'orageneric9.dll'. Read of address 00000014. If a select is done on the XMLType column alone, the following error occurs along with the same run on condition of WinSQL: Access violation at address 0180C3F6 in module 'orageneric9.dll'. Read of address 00000014.

I don't think XML types are supported by ODBC. Check Oracle's documentation. Jack >When doing a SQL select on an Oracle table containing a column of XMLType, the following >error is returned. Reconnection to the database is then necessary as the query appears >to run on indefinately and can not be stopped by pressing the stop button: > >Access violation at address 04C0F368 in module 'SQORA32.DLL'. Write of address 01A4F000. > >or, >sometimes, > >Access violation at address 0180C3F6 in module 'orageneric9.dll'. Read of address >00000014. > > >If a select is done on the XMLType column alone, the following error occurs along >with the same run on condition of WinSQL: > >Access violation at address 0180C3F6 in module 'orageneric9.dll'. Read of address >00000014.