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
ORA-24813 cannot send or receive an unsupported LOB
-
- Devart Team
- Posts: 2420
- Joined: Wed 02 Nov 2011 09:44
Re: ORA-24813 cannot send or receive an unsupported LOB
We have answered you via e-mail.
Re: ORA-24813 cannot send or receive an unsupported LOB
I can't attach files in post?
Send you by mail
Send you by mail
-
- Devart Team
- Posts: 2420
- Joined: Wed 02 Nov 2011 09:44
Re: ORA-24813 cannot send or receive an unsupported LOB
It is not possible to attach a file to a forum post. We have answered you by e-mail.