Commits in your code

Put them in your frakking code, not in the backend PL/SQL Function or Procedure.
What happens when something goes wrong and you need to rollback ?? You can't because you insisted on having the commit/rollback functionality removed from you because you can't use a connection manager correctly.

For the love of all things holy, learn where best to manage from.

/rant off