Problem
FUNCTION get_state_rules_fun (p_state IN varchar2)
RETURN state_sales_tax_rules%rowtype IS
v_st_rules state_sales_tax_rules%rowtype;
BEGIN
select *
into v_st_rules
from state_sales_tax_rules
where state = p_state;
return(v_st_rules);
exception
when others then
message('get_state_rules_fn err ='||sqlerrm);
raise;
END;
Solution:
Though it is returning correct value in the SQL,TOAD it may through errors
Reason:The field which is defined in the form may be in different format
We have to handle exceptions
Read More on %ROWTYPE
%ROWTYPE in Cursor
