Calling Procedure with table param via LinqConnect

Calling Procedure with table param via LinqConnect

Postby killpapa » Tue 10 Oct 2017 09:00

Hello all!

Is it possible to generate a procedure with a parameter TABLE_OF_XXL in LinqConnect?
Code: Select all
FUNCTION f_XXL
  ( p in TABLE_OF_XXL)
  RETURN  number IS
BEGIN
for i in 1..3 loop
insert into test_xxl (f,d)  values (p(i), sysdate);
end loop;
return 5;
END;

Code: Select all
type TABLE_OF_XXL as table of XXL

Code: Select all
type XXL as object (n number, v varchar2(120), dt date)


in 9.4.348 did not work out (
killpapa
 
Posts: 17
Joined: Sun 29 Jan 2012 16:12

Re: Calling Procedure with table param via LinqConnect

Postby killpapa » Tue 10 Oct 2017 12:52

killpapa
 
Posts: 17
Joined: Sun 29 Jan 2012 16:12

Re: Calling Procedure with table param via LinqConnect

Postby killpapa » Wed 11 Oct 2017 12:24

Help me, my dear frends!
killpapa
 
Posts: 17
Joined: Sun 29 Jan 2012 16:12


Re: Calling Procedure with table param via LinqConnect

Postby killpapa » Thu 12 Oct 2017 10:54

ok, tnank you
killpapa
 
Posts: 17
Joined: Sun 29 Jan 2012 16:12


Return to dotConnect for Oracle