issue in BIP report when a global variable carrying a sting with single quotes in middle of name

Hi Gurus,

I have a xml data definition in which I have a sql statement which uses a global variable in the select list


for example Select  &name, &Location from dual;

&name and & location values comes from a default package for this data definition  and the values in these variable are like &name = O'niel   and & location = State's

when there is a single quote in the values the query is running into error

ORA-00923: FROM keyword not found where expected .

Please provide your inputs / share any idea to resolve this issue

Thanks in advance