1. Some applications can't tolerate the roundtrip latency, so the typical way is to put the business logic inside the stored procedure.
2. DBA wants to guard the database.