I have a serious problem with returning a "table" from a package to my C# program.
I declared the following TYPE in the package:
Code: Select all
TYPE RetValUldDouble IS TABLE OF CHCSDBSHM.I_ULD_PRED_DATA%ROWTYPE INDEX BY BINARY_INTEGER;
Then the function:
Code: Select all
FUNCTION FN_I_GET_ALL_ULD_FROM_MV2(i_MvmNr IN VARCHAR2, i_SrtDt IN VARCHAR2) RETURN RetValUldDouble
It's a table with about 40 columns.
Declaration in the main function:
Code: Select all
v_UldArr RetValUldDouble;
The C# ReturnValue Parameter is declared:
Code: Select all
oraComm.Parameters.Add("o_RetVal", OracleDbType.Array).Direction = ParameterDirection.ReturnValue;
When calling ExecuteNonQuery i get the following error message:
ORA-03115 unsupported network datatype or representation
Any ideas how I can return this multi column "table" to the program?
I have no problems with cursors or Tables with single columns like:
Code: Select all
TYPE RetVal IS TABLE OF VARCHAR2(12) INDEX BY BINARY_INTEGER;
Code: Select all
TYPE RetValUldDouble IS TABLE OF CHCSDBSHM.I_ULD_PRED_DATA%ROWTYPE INDEX BY BINARY_INTEGER;
We use dotConnect for Oracle Professional Edition 5.25.49.0; VS2005 and Oracle 10g
Many Thanks in advance