日期:2014-05-16  浏览次数:20412 次

ORACLE函数传入TYPE参数
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