Help for this page
$sth->prepare("exec my_proc '$foo'"); # single quotes added
$sth->prepare("exec my_proc 'D_CHRIS'");