|
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
|
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
|