table of integer

[nijburg]

Does anybody know how to pass data to a table of integer type parameter from a TOracleQuery ??

Type t_NumberTable is table of number

Rgds,
Ewart

 

[Marco Kalter]

If this is a PL/SQL table (index by binary_integer), then you can access is as a variant array. See the PL/SQL Table section in the User's Guide or Help File for detailed information.

If this is a nested table, you can access it as a TOracleObject. It must be created through a "create or replace type t_NumberTable as table of number" though.

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

 

[nijburg]

Hi Marco,

It is a nested table and I tried the TOracleObject, but can't get it to work.

What values should the parameters in the constructor be ?

Rgds, Ewart

 

[Marco Kalter]

The constructor of the TOracleObject should be something like this:

MyTable := TOracleObject.Create(MySession, 't_NumberTable', '');

The t_NumberTable object must be created through a "create or replace type" command though.

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