storedprocs-javasql

- insertion and retrieval of the unique id is done in two steps(two db calls) if you were to implement using java approach. this can be simplied if you were to implement it in stored procedure. 
- Maintenance of any structural changes are always easier  at oracle/db end when compared to doing it at java end
- code is much cleaner if done at db end rather than doing it at java end
- perfect use case which is in favor of keeping the save logic at the DB end is 
  
  Multiple saves in One Single page
  Project -> Project
  Project -> ProjectBusiness
  Project -> businesses
  Project -> country
  Project -> entity
  Project -> contacts
  Project -> advisors
  Project -> Assets