Total Pageviews

July 13, 2016

7/13/2016 08:07:00 AM


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
 
Related Posts Plugin for WordPress, Blogger...