How to avoid Value_error exception in forrmula coloumn in oracle reports
Dear Team,
I have created on formula coloumn but it is going in value error in exception .
I observed that because of '%' .
my below query output is : 80% TRC 10 % REC OF MATL 10 % PBG
select DESCRIPTION
-- INTO lc_payment_terms
from apps.oe_order_headers_all oha
, apps.ra_terms rat
where oha.PAYMENT_TERM_ID = rat.term_id
AND oha.order_number = :Contract_No--70100028
AND oha.org_id = :org_id--87
but not printed output in oracle report PDF format not also printing in XML output also.
Please suggest me .
Regards,
Sandip Chakor