Oracle SQL & PL/SQL: Oracle PL/SQL REF Cursors

Another difference is that static SQL (not using a ref cursor) is much more efficient then using ref cursors and that use of ref cursors should be limited to. returning result sets to clients when there is NO other efficient/effective means of achieving t

sql-plsql.blogspot.com