Total Pageviews

July 12, 2016

7/12/2016 07:37:00 PM


Oracle Forms



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

0 comments:

Post a Comment