The first web application I did, that went in production 22 years ago, was in it's entirety based on stored procedures. This was the main idea of Oracle's web application services at that time.
But, you have a very big tradeoff - you will be stuck with that database. Hardly portable.