How to retrieve PL/SQL table of records

[Ender]

Hi, all.

I'm trying to guess how to retrieve/inject table of records from/to stored procedure. I see there are TPLSQLTable and TPLSQLRecord types, but i cannot understand how to make them work together. Any demo application exists? Is there any other way?

 

[Devil]

Попробуй при помощи Package Wizard сгенерировать Delphi class для пакета в котором хранится твоя функция/процедура(я не привожу пример, т.к. там много чего генерится). PLSQL таблица будет хранится в классе TOracleObject, ну а как с ним работать, разбирайся сам. Удачи

 

[Marco Kalter]

Tables of records are not supported. You would have to use a collection type (varray, nested table) for that.

The 2 types you mentioned are used by the Package Wizard, but only for single records and tables of scalar data types.

 

[Ender]

Is this feature not supported only because it is not implemented in current version of DOA (can be implemented in the future versions) or because it is not possible because lack of OCI features?

As workaround i created table of scalars

type TStringList is table of Varchar2(...) index by binary_integer;

... packed record data in it

S(I):='Field1=' || to_char(Record1.Field1) || ...

and passed it outside of PL/SQL block as parameter

 

[Marco Kalter]

There is unfortunately no OCI functionality to pass records or tables of records, so it cannot be supported.