I can't get Collection values in OracleDataSet component.

[eliasyac]

I can't get Collection values in OracleDataSet component.

in Oracle:
/*
create or replace type t_dummy as varray (1024) of varchar2(100); create table dummy (code number, field1 t_dummy); insert into dummy values(1, t_dummy('value1', 'value2', 'value3', 'value4')); commit; */

in delphi:

procedure TForm1.Button6Click(Sender: TObject); var
FGeometry: TOracleObject;
ods: TOracleDataSet;
begin
ods := TOracleDataSet.Create(self);
ods.Session := OracleSession1;
ods.sql.add('select t.field1, t.rowid from dummy t where code=1'); ods.open; FGeometry := ods.CreateObject('field1'); if FGeometry.isNull then ShowMessage('object is null'); ods.free; end;

This message shows, i.e. object FGeometry has no data.

DOA 4.0.1
Delphi 5 Enterprise
Oracle 8.1.7.
-----------------------

 

[Marco Kalter]

I was able to reproduce this issue with your example. We'll look into this.