$sth->prepare("exec my_proc '$foo'"); # single quotes added
##</code><code>##

$sth->prepare("exec my_proc 'D_CHRIS'");