Type t_tb_rate2 is table of number (20, 8) index by varchar2 (50);
Saved in:
Define v_tb_rate t_tb_rate2;
Through the cursor to v_tb_rate assignment
Will this table type as a parameter to f_get_act_rate () function returns a numeric value
F_get_act_rate (c_res_kind, c_res_prod c_inwd_mrk, 'and', '013003', v_tb_rate))
Now compile packet error "error: PLS - 00382: expression type error"
How should change? Please god help me, online etc.!
CodePudding user response:
Declarations in the package type t_tb_rate2 is table of number (20, 8) index by varchar2 (50);CodePudding user response:
Type t_tb_rate2 is table of number (20, 8) index by varchar2 (50);This out of the bag, defined as global