Originally Posted by rahulrathod

Hi All,

I pass a Perl script variable, whch is passed to a query to be prepared. But the problem is I have special character like '&' in this variable which are handled in a special way by the Oracle query parser. How do I get over this?

my $cust_name='A&B';
my $sql="Select cust_short_name from lu_customers where cust_full_name = '$cust_name' ";

Thanks,
Rahul