Access violation with BLOB

[Spit]

Hello Marco.

Place to form the next components:

btnButton1, OracleDataSet1, OracleLogon1 and OracleSession1.

Replace "any_table_with_blob" with real table name with BLOB in your base.

Create event for button:
procedure TfrmMain.btnButton1Click(Sender: TObject);
begin
OracleLogon1.Execute;
OracleDataSet1.Session := OracleSession1;
OracleDataSet1.SQL.Text := 'select * from any_table_with_blob where rownum < 2';
OracleDataSet1.Close;
OracleDataSet1.Open;
OracleSession1.Connected := False;
end;

Push the button, logon and close the form...
You should receive "Access violation..."

If you need demo project i can send it.

With best regards,
Spit

 

[Jean-Louis GOUEZ]

Hi Spit,

I have a problem like yours at my office.
I use C++ Builder 5 on an Oracle 8i database and when I open a query (TOracleQuery) containing a BLOB, I cannot close it.
If I try to call the Close() method, then I get an Access violation error and if I don't close the query, I quickly obtain an ORA-1000 (Too many open cursors) error message.

If anyone has an idea, it would be great.

Thank by advance.
Best regards,
Jean-Louis

 

[Marco Kalter]

If you can send me your demo project and table definition that would be nice.