Oracle 21c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE PACKAGE pck as
  TYPE args_r IS  record (
    q    integer,
    b    INTEGER
  );

  TYPE args_t IS TABLE OF args_r;
  
  FUNCTION f RETURN args_t PIPELINED;
  FUNCTION f2 RETURN args_t;

  FUNCTION create_arg(q INTEGER, b INTEGER) RETURN args_t PIPELINED;
  FUNCTION create_arg2(q INTEGER, b INTEGER) RETURN args_t;
  FUNCTION g(args IN args_r) RETURN INTEGER;
END;
/
CREATE PACKAGE BODY pck as
  FUNCTION f RETURN args_t PIPELINED
  IS 
  BEGIN
    PIPE ROW (args_r(1,1));
    PIPE ROW (args_r(2,2));
  END;

  FUNCTION f2 RETURN args_t
  IS 
  BEGIN
    RETURN args_t(args_r(1,1), args_r(2,2));
  END;

  FUNCTION create_arg(q INTEGER, b INTEGER) RETURN args_t PIPELINED
  IS
  BEGIN
    PIPE ROW (args_r(q, b));
  END;

  FUNCTION create_arg2(q INTEGER, b INTEGER) RETURN args_t
  IS
  BEGIN
    RETURN args_t(args_r(q, b));
  END;

  FUNCTION g(args IN args_r) RETURN INTEGER
  IS
  BEGIN
    RETURN args.q;
  END;
END;
/
SELECT * FROM USER_ERRORS;
SELECT *
FROM   TABLE(pck.f());


Q
B


1
1

2
2


SELECT *
FROM   TABLE(pck.f2());
ORA-00902: invalid datatype

SELECT pck.g(pck.args_r(1,1))
FROM   DUAL;
ORA-06553: PLS-306: wrong number or types of arguments in call to 'ARGS_R'

SELECT pck.g((SELECT VALUE(t) FROM TABLE(pck.create_arg(1,1)) t))
FROM   DUAL;


PCK.G((SELECTVALUE(T)FROMTABLE(PCK.CREATE_ARG(1,1))T))


1


SELECT pck.g((SELECT VALUE(t) FROM TABLE(pck.create_arg2(1,1)) t))
FROM   DUAL;
ORA-00902: invalid datatype