Hi,

I've a C++ program that has to pass values contained in an array of structs to a PL/SQL package which has to manipulate the data.

My problem is in understanding which is the corresponding type to the array of struct in the package.

For example, consider the array declared as:

typedef struct my_cell {
char My_Local_Cell_ID[12];
int My_Logical_Cell_Id;
int My_Value;
char My_Is_Group[3];
char My_Group_Id[12];
} mycell[10];

thecell mycell;

...

Afterwards I call a procedure in the package:

EXEC SQL EXECUTE
BEGIN
manage_nodeb.put_values
(:mycell);

END;


Now my problem is in understanding what Type I have to declare in tha PL/SQL package in order to pass the values to the PL/SQL procedure put_values.

Procedure put_values( ??? ) IS (...)


I tried with

TYPE cellrec IS RECORD (
local_cell_id cell.local_cell_id%type,
logical_cell_id cell.logical_cell_id%type,
value cell.value%type,
is_group cell.is_group%type,
gruop_id cell.group_id%type );

TYPE mycell IS TABLE OF cellrec INDEX BY BINARY_INTEGER;

but it seems not to work...

Thanks for heping
Paolo