Calling Procedure with table param via LinqConnect
Posted: Tue 10 Oct 2017 09:00
Hello all!
Is it possible to generate a procedure with a parameter TABLE_OF_XXL in LinqConnect?
in 9.4.348 did not work out (
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)