brahma

Will the quote method work for you? I know it will take care of quotes but I'm not certain about the ampersand but check DBD::Oracle to see if it has any special quote methods.

$var = $dbh->quote( "This is a & funny ones'" );
print $var, "\n";
[download]

-derby