ODP.NET

Hi there,

I'M using a 10g database with a stored procedure that has an input parameter that can carry several integer values. To do this is made a type like this:

TYPE tab_arr IS VARRAY (4) OF NUMBER;

The input parameter looks like this:

P_PRODUCTS IN tab_arr

For some reason I'm not able to pass ANY array to this parameter in .NET in VIsual Studio 2008.

I use the DevArt Data Provider and keep on getting the ORA-03115 error: unsupported network datatype or representation.



I also tried the following way: 1. Defining a type (CREATE TYPE QRODUCTS_ARRAY AS VARRAY (4) OF NUMBER;) and instantiate a OracleArray in the VB Code:

Dim oOracleVarray As New Oracle.OracleArray("SA.QPRODUCTS_ARRAY", conConnection)

No success. It can't be that difficult to hand a few numbers over to an procedure?

Any hint is appreciated!

Thanks
Mat