Hi,
We have many INSERT statements embedded in our Java front-end Web code and would prefer to move these statements closer to the Database within Oracle objects (procedures) for ease of maintenance and not having SQL DMLs spread across our entire Java front-end code. My questions are:
1. Are there any best practices regarding having DML statements embedded in Java vs in Oracle procedures?
2. If Oracle procedures should handle DMLs, is the best way to send large amount of Web form data from Java to Oracle is by using Oracle Types?
Oracle version: Oracle Database 11g Release 11.2.0.4.0 - 64bit
Java: 1.8.0_191
I am trying to find the best practice for these scenarios, as I believe DMLs should be handled near the DB and not on the client site.
Any inputs will be highly appreciated.
Thanks