Table of records as in or out param in func or proc?

Table of records as in or out param in func or proc?

Postby fredlegrain » Tue 12 Jul 2011 10:53

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# ?

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;
fredlegrain
 
Posts: 8
Joined: Tue 12 Jul 2011 09:47

Postby fredlegrain » Tue 12 Jul 2011 13:58

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.

Anyone can help?
fredlegrain
 
Posts: 8
Joined: Tue 12 Jul 2011 09:47

Postby fredlegrain » Thu 14 Jul 2011 11:18

I'd be glad even if I'm getting a negative answer...
fredlegrain
 
Posts: 8
Joined: Tue 12 Jul 2011 09:47

Postby Shalex » Thu 14 Jul 2011 15:52

User-defined types declared in a package cannot be used outside of this package. We suggest defining these types globally. We have sent a modified sample by e-mail.

Our support has a two business days response policy, but we do our best to respond as soon as possible.
Shalex
Devart Team
 
Posts: 7612
Joined: Thu 14 Aug 2008 12:44

Postby fredlegrain » Fri 15 Jul 2011 08:19

Thank you for the support.
Your answer is of real value.

Don't worry about my remark ;-)
fredlegrain
 
Posts: 8
Joined: Tue 12 Jul 2011 09:47

the same issue

Postby ying515_huang » Mon 22 Aug 2011 02:48

we have the same issue! please get me modified sample!
my email:ying515.huang@msa.hinet.net
ying515_huang
 
Posts: 13
Joined: Mon 21 Feb 2011 03:35

Postby Shalex » Thu 01 Sep 2011 11:02

ying515_huang,
We have sent the modified sample to your e-mail. Please remove the e-mail address from your post to avoid spam attacks. Sorry for the delay.
Shalex
Devart Team
 
Posts: 7612
Joined: Thu 14 Aug 2008 12:44


Return to dotConnect for Oracle