Calling Procedure with table param via LinqConnect

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
killpapa
Posts: 19
Joined: Sun 29 Jan 2012 16:12

Calling Procedure with table param via LinqConnect

Post by 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: 19
Joined: Sun 29 Jan 2012 16:12

Re: Calling Procedure with table param via LinqConnect

Post by killpapa » Tue 10 Oct 2017 12:52


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

Re: Calling Procedure with table param via LinqConnect

Post by killpapa » Wed 11 Oct 2017 12:24

Help me, my dear frends!

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Re: Calling Procedure with table param via LinqConnect

Post by Shalex » Wed 11 Oct 2017 15:13

LinqConnect supports only primitive types which are listed at https://www.devart.com/linqconnect/docs ... pping.html.

To work with NESTED TABLE and Oracle Object, please use a plain ADO.NET:
https://www.devart.com/dotconnect/oracl ... Table.html
https://www.devart.com/dotconnect/oracl ... bject.html

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

Re: Calling Procedure with table param via LinqConnect

Post by killpapa » Thu 12 Oct 2017 10:54

ok, tnank you

Post Reply