Skip to Main Content

Wrapper Java Classes on PLSQL objects

JayAroraMar 11 2018 — edited Mar 12 2018

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

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked due to inactivity on Apr 9 2018
Added on Mar 11 2018
2 comments
657 views