Disclaimer: APEX dev team member here. Independent of APEX and even the Oracle database, if you are not using stored procedures, you are not using the database efficiently. See e.g. this presentation for a performance analysis: https://www.youtube.com/watch?v=jfkph4lXmKU