Is there any official documentation on the pros/cons of using Hibernate (or ORM in general) vs. stored procedures for all CRUD operations?

Obviously for application portability benefit, it's safe to use JPA with Hibernate as your persistence provider, for example, and when you change RDBMS from MSSQL to Oracle, for example, you're safe. This is not necessarily true with using sprocs for full CRUD.

Also, Hibernate offers 1st and 2nd level caches.

Is there a complete list for this? Also, things like security and performance?