I'm not an experienced DBA. I know there are certainly companies who don't do it like that, but I don't have statistics.
But I'd personally favor creating some (stateless) API that does as many of the procedures as possible. For these reasons:
But that's just my personal view, leave a comment if you disagree.
(As for the validation of results you gety back: there are definitely libraries for that in various langauges.)