Calling Procedure with table param via LinqConnect

[killpapa]

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]

this https://www.devart.com/dotconnect/oracl ... izard.html works with LinqConnect?

[killpapa]

Help me, my dear frends!

[Shalex]

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]

ok, tnank you