I am new in BI and I develop a procedure with call of different functions. How can I get back these 20 functions and throw them in a PIPELINED TYPE?
This information will be of type query, as it will be a query on a front. I can not ride this Pl-sql.
I'm sending a simple example as I want.
Thanks for your help.
create or replace PROCEDURE proc_test (p_ISS IN number,
number p_COFINS IN,
Number P_IR IN,
P_IMPOSTO IN number,
Number P_TAXA IN) AS
v_num1 NUMBER: = 0;
v_num2 NUMBER: = 0;
v_num3 NUMBER: = 0;
v_num1: = fn_ISS (p_iss, p_COFINS);
v_num2: = fn_ir (P_IR, P_IMPOST);
v_num3: = fn_load (P_TAXA, P_IMPOST, p_ISS);
Thank you very much!