OCI: Example code of Binding VARRAY containing a UDT.

I have been unable to successfully insert a UDT into a table with a column for a varray of these UDTs. I was wondering if I could find any such code example here.

My UDT is a simple one :

struct my_Struct {
OCIString *name;
};

which is a typed object in the database: create type my_type as object ( obj1 varchar (255));

while the containing array is defined as:

create table OBJ2 AS VARRAY(10) OF my_type;

the table itself is a single column of type OBJ2.

Thanks, in advance.

-talha Received on Thu Jun 18 1998 - 20:30:47 CEST