日期:2014-05-16 浏览次数:20412 次
SQL> create type test_type as object(a varchar2(10),b number); 2 / Type created SQL> SQL> create or replace function fun_test(a in test_type) return number is 2 aa number; 3 begin 4 aa := a.b + 1; 5 return aa; 6 end; 7 / Function created SQL> select fun_test(test_type('xx', 3)) from dual; FUN_TEST(TEST_TYPE('XX',3)) --------------------------- 4