send a table of records from pro C to Oracle pl/sql stored procedure

[Eranut]

Hi,

I am trying to understand if there is a way to send a table of records
(table of structs) from pro C to Oracle pl/sql stored procedure.
Since Oracle is demanding definition of the *sent* array exactly as it
is define in the *recieving* end I am not sure it is possible.

Thanks
Eran

[Mark D Powell]

er****@gmail.com (Eranut) wrote in message news:<c8*************************@posting.google.c om>...

Hi,

I am trying to understand if there is a way to send a table of records
(table of structs) from pro C to Oracle pl/sql stored procedure.
Since Oracle is demanding definition of the *sent* array exactly as it
is define in the *recieving* end I am not sure it is possible.

Thanks
Eran

Look up array inserts and bulk load in the manuals. You can also call
a stored procedure or submit anonymous code from a Pro*c program.

Which, depends on exactly what you want to do.

You may get more responses if you posted in the
comp.databases.oracle.tools group.

HTH -- Mark D Powell --