Oracle blob with C#

  • Thread starter Thread starter bumbazz
  • Start date Start date
B

bumbazz

Hi all,
I need to know how to read and write an Oracle blob with
C#. I'm using a NT4 SP6 workstation with MS .Net 1.0 and
the code I wrote is:

public void LoadUtenti()
{
const string SLQ_SELECT_UTENTI = "SELECT Utente,
Nominativo, Tipo, Area, Firma, Sigla, Manager, CanDo FROM
Utenti";

this.daRLPE = new OleDbDataAdapter(SLQ_SELECT_UTENTI,
this._cnnConnection);

this.daRLPE.Fill(this._dtRLPEDataTable);

this._dtRLPEDataTable.DefaultView.AllowDelete = false;

}

but during the Fill of _dtRLPEDataTable I have a crash.
The blob column is "Firma" and if I exclude this field the
code works well.

The namespaces I'm using are:

using System;
using System.Data;
using System.Data.OleDb;

Is there a method to read and write an oracle blob field?
I need to update and delete it too.

Thank you very much,
Alessandro.
 
Back
Top