in reply to Problem in passing value to a PL/SQL block

Use placeholders. The new sql snippet
where custdata2.code = ?;
And the execute statement
$sth->execute($user_location) or die $dbh->errstr;
- Miller