I have oracle form having fields like 1) Store Name and 2) Store Number. When I query the form using Store Number then form is retriving the store name for any given Store Number.
But when I query by store name having with apostraphe(Anne's Grocery store, Jeffy's Lube --etc) the form is failing to retrive any information.
in the database the some store name column contains apostrphe in it (Anne's Grocery store, Jeffy's Lube) . It is not permitted to change\clean the database data side.
How to fix code in the form so that form can query by store name contains apostrphe without any issues.