F


<DEFAULT SERVER>   >   <DEFAULT DATABASE>   >   <DEFAULT SCHEMA>   >   F   

Function body F(I_1 NUMBER,I_2 NUMBER,I_3 NUMBER) return T_OUT_PARAMS_TAB

Name Datatype Precision Description
I_1 number NUMBER
I_2 number NUMBER
I_3 number NUMBER
Name Types Value
No Data
Name Definition
No Data

create function f(i_1 number, i_2 number, i_3 number) return t_out_params_tab pipelined as
begin
  -- in this example I just calculated things with the input parameters
  -- you can run your logic or stored procedure and get the 4 out parameters
  -- instead (should initialize t_out_params)
  pipe row(t_out_params(i_1*2, i_2+10, i_3, i_1+i_2+i_3));
return;
end

     
Name Types Description
<DEFAULT SCHEMA>.T_OUT_PARAMS_TAB Type Type interface
NUMBER PL/SQL System type PL/SQL System Object
T_OUT_PARAMS Undefined Procedure Function interface T_OUT_PARAMS() return Virtual

     
No Data