Table of records as in or out param in func or proc?
Posted: Mon 22 Aug 2011 02:51
Hello,
Ca you tell me how I can call that kind of procedure/function with table of records as input or output parameters and make use of it in C# ?
OraclePackage.DescribeProcedure returns 5 parameters
IN1, IN2, OUT1, OUT2$SOME_ID, OUT2$SOME_STRING
But using these parameters for a call... fails.
Watching the Non-Public members of the OUT2 parameters, I came to see that it knows about T_RECORD type... So I'm a bit disappointed.
Ca you tell me how I can call that kind of procedure/function with table of records as input or output parameters and make use of it in C# ?
OraclePackage.DescribeProcedure returns 5 parameters
IN1, IN2, OUT1, OUT2$SOME_ID, OUT2$SOME_STRING
But using these parameters for a call... fails.
Watching the Non-Public members of the OUT2 parameters, I came to see that it knows about T_RECORD type... So I'm a bit disappointed.
Code: Select all
CREATE OR REPLACE PACKAGE PCK_TESTDEVART AS
TYPE t_reccord IS RECORD (some_id integer, some_string varchar2(10));
TYPE t_records IS TABLE OF t_reccord Index By Binary_Integer;
PROCEDURE sp05(
in1 in integer,
in2 in t_records,
out1 out integer,
out2 out t_records
);
FUNCTION func05(
in1 in integer,
in2 in t_records,
out1 out integer,
out2 out t_records
) return integer;
END PCK_TESTDEVART;