1

Topic: Analog TPLSQLTable in ODAC

Good afternoon, friends!
Decided to replace components Direct Oracle Access (DOA) on ODAC. It is a lot of pluses, but one got .
In DOA-shnyh components actively  class TPLSQLTable, but I did not find such analog in ODAC-ovskih components.
Or I not well enough searched? If who faced such problem, prompt where to search.
Thankful in advance

2

Re: Analog TPLSQLTable in ODAC

Yury wrote:

Good afternoon, friends!
Decided to replace components Direct Oracle Access (DOA) on ODAC. It is a lot of pluses, but one got .
In DOA-shnyh components actively  class TPLSQLTable, but I did not find such analog in ODAC-ovskih components.
Or I not well enough searched? If who faced such problem, prompt where to search.
Thankful in advance

I do not know, what for it is used, but the description of this class simple enough.
You can pull out it to yourself and use further.

TPLSQLTable = class (TObject)
private
FValues: Variant;
FTableSize: Integer;
FStringSize: Integer;
function GetValue (Index: Integer): Variant;
procedure SetValue (Index: Integer; const Value: Variant);
function GetCount: Integer;
procedure SetCount (Value: Integer);
procedure SetTableSize (Value: Integer);
function GetAsString: string;
procedure SetAsString (const Value: string);
public
constructor Create (ATableSize, AStringSize: Integer);
procedure Assign (Source: TPLSQLTable);
property Values [Index: Integer]: Variant read GetValue write SetValue; default;
property TableSize: Integer read FTableSize write SetTableSize;
property StringSize: Integer read FStringSize write FStringSize;
property Count: Integer read GetCount write SetCount;
property AsString: string read GetAsString write SetAsString;
property ValueArray: Variant read FValues write FValues;
end;

3

Re: Analog TPLSQLTable in ODAC

Among the components which are a part ODAC, there is direct analog TPLSQLTable. However you can work with collections PL/SQL as follows: https://www.devart.com/odac/docs/work_plsqltables.htm

4

Re: Analog TPLSQLTable in ODAC

devart;
That is, to transfer the table it is necessary to transform each element of the list thus?
And how to receive the table of procedure?
DataType can only String be?

5

Re: Analog TPLSQLTable in ODAC

defecator;
Class not a problem to pull, a problem in its further usage

6

Re: Analog TPLSQLTable in ODAC

Yury wrote:

That is to transfer the table it is necessary to transform each element of the list thus?

PLSQLTable it is simple an array of values. We did not begin to create a separate component for this purpose. If at you a lot of code it is fastened on TPLSQLTable as you wrote above can create the class with such title both teach him  and be deserialised yourself in/from parameter.

Yury wrote:

And how to receive the table of procedure?

To declare parameter as ptOutput and after procedure performance to subtract from it an array of values.

Yury wrote:

DataType can only String be?

No, any type.