howto return TYPE IS TABLE OF from Package into C#
Posted: Thu 25 Mar 2010 02:32
Hello,
I have a serious problem with returning a "table" from a package to my C# program.
I declared the following TYPE in the package:
[/color]
Then the function:
[/color]
It's a table with about 40 columns.
Declaration in the main function:
v_uldArr is filled in this function and is returned at the end of the function
The C# ReturnValue Parameter is declared:
I tried it also with OracleDbType.Table but without success.
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:
But with multi-column table like the above mentioned:
[/color]
We use dotConnect for Oracle Professional Edition 5.25.49.0; VS2005 and Oracle 10g
Many Thanks in advance
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