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)