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