Devart Forums

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

We have answered you via e-mail.

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

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