CREATE OR REPLACE TYPE arguments_r IS OBJECT
(
q integer,
b INTEGER
);
Type created.
CREATE OR REPLACE FUNCTION f (p IN arguments_r)
RETURN INTEGER
IS
BEGIN
RETURN 1;
END;
Function created.
with a(a1,a2) as (select 1 , 2 from dual)
select f(arguments_r(a1,a2 )) from a
F(ARGUMENTS_R(A1,A2)) | 1 |
---|
with a(a1,a2) as (select 1 , 2 from dual)
select f(arguments_r(a.* )) from a;
with a(a1,a2) as (select 1 , 2 from dual)
select f(CAST(a.* AS arguments_r) ) from a;