DOA 3.3.1, parameter passing

[zhives]

Hi,

I'd like to pass array parameter with DOA 3.3.1 to a SP like this:

create procedure MyProc (T in X_Table);

where X_Table is my own type:

create type X_Item as object (N number);
create type X_Table as table of X_Item;

How can I do it from Delphi 5 Prof? Any advice would be very helpful!

Zoltan Hives

(Excuse me posting topic
"TOracleObject.Create with" with unfinished and meaningless subject.)

 

[Marco Kalter]

create a TOracleQuery with a PL/SQL Block like this:

begin
  myproc(:x_table);
end;

Declare the x_table variable as an Object variable, and use TOracleQuery.SetComplexVariable to assign a TOracleObject instance of the correct type before execution.

------------------
Marco Kalter
Allround Automations