Devart Forums

Code: Select all

create or replace
FUNCTION F_TEST(test varchar2) RETURN test_table_of_tests AS
  v_ret test_table_of_tests;
BEGIN
  v_ret := test_table_of_tests();
  v_ret.extend;
  v_ret(v_ret.count) := test_type_test(1, test);
  return v_ret;
END F_TEST;

Code: Select all

create or replace
type test_table_of_tests as table of test_type_test

Code: Select all

create or replace
TYPE TEST_TYPE_TEST  AS OBJECT
    ( id           NUMBER
    , test        VARCHAR2(10)
   ) ;