Hello Guru's,
I would like to seek your inputs how should we design wrapper classes on PLSQL objects.
https://docs.oracle.com/en/database/oracle/oracle-database/12.2/jjdev/calling-PL-SQL-from-Java.html#GUID-F2FC29B6-F20F-4… https://docs.oracle.com/en/database/oracle/oracle-database/12.2/jjdev/calling-PL-SQL-from-Java.html#GUID-F2FC29B6-F20F-49FB-99CB-56C9C15ECFB5
We can use callabale statements to call stored objects. Our idea is to create java clasess which can call these PLSQL objects and other developers who want to call these plsql objects should create an object of this java class and call appropirate java method. So in future, if there is a change in DB we should only update the wrapper class and the consuming class will not change. We woul also be able to achieve an abstraction layer.
Is my thought in right direction ? Also, if some one can share some blog/links that we can refer to that would be great.
Appreciate your thoughts.
Regards,Jay