ORA-24813 cannot send or receive an unsupported LOB

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
ageinfo
Posts: 2
Joined: Fri 03 Jun 2016 13:11

ORA-24813 cannot send or receive an unsupported LOB

Post by ageinfo » Mon 06 Jun 2016 08:52

Hello

Enviroment:
Oracle 10g
Windows 7 Ult x64

Problem
With datadapter i have this exception when try to fill datatable and the table have CLOB type

Code:
Public Shared Function GetDtDataAdapterDevart(ByVal strsql As String) As _SqlDataAdapterYDatatable
Dim _SqlDataAdapterYDatatable As New _SqlDataAdapterYDatatable

Try
'Devart.Data.Oracle.OracleUtils.UseDirectLobs = False 'viewtopic.php?t=13518

'Using cn As New Devart.Data.Oracle.OracleConnection(_strCCOracleClientODAC)
Dim cn As New Devart.Data.Oracle.OracleConnection(_strCCOracleClientODAC)
With _SqlDataAdapterYDatatable
._DataTable = New DataTable
._DataAdapter = New Devart.Data.Oracle.OracleDataAdapter(strsql, cn)

'Puede dar error
._Builder = New Devart.Data.Oracle.OracleCommandBuilder(._DataAdapter)
._DataAdapter.UpdateCommand = ._Builder.GetUpdateCommand
._DataAdapter.InsertCommand = ._Builder.GetInsertCommand
._DataAdapter.DeleteCommand = ._Builder.GetDeleteCommand

Try : ._DataAdapter.Fill(._DataTable)
Catch ex As Exception : Throw
End Try
End With
' End Using
Catch ex As Exception : Throw
'Finally : If Not _bolVieneDataAdapter Then _SqlDataAdapter.Dispose()
End Try
Return _SqlDataAdapterYDatatable
End Function

Notes
I read this old post but doesn't have property UseDirectLobs: viewtopic.php?t=13518

Any news
Thanks

Pinturiccio
Devart Team
Posts: 2420
Joined: Wed 02 Nov 2011 09:44

Re: ORA-24813 cannot send or receive an unsupported LOB

Post by Pinturiccio » Wed 08 Jun 2016 14:11

We have answered you via e-mail.

ageinfo
Posts: 2
Joined: Fri 03 Jun 2016 13:11

Re: ORA-24813 cannot send or receive an unsupported LOB

Post by ageinfo » Wed 08 Jun 2016 15:53

I can't attach files in post?
Send you by mail

Pinturiccio
Devart Team
Posts: 2420
Joined: Wed 02 Nov 2011 09:44

Re: ORA-24813 cannot send or receive an unsupported LOB

Post by Pinturiccio » Mon 13 Jun 2016 14:21

It is not possible to attach a file to a forum post. We have answered you by e-mail.

Post Reply