How to create native function in java for Oracle subd?

Question

Oracle

I don’t know how to implement encryption using the elliptic curve algorithm of the database, I didn’t find it in the built-in methods. It turns out that you need to create a procedure that, when inserting data, was entered into the database in encrypted form, and when selecting data, it would be displayed decrypted, unfortunately I could not find at least an outline, maybe someone has already done it? or can share experience in this matter?
Here on the forum it was suggested that the above can be implemented using native java. That's just, I couldn't find anything normal about native functions in java for Oracle, tell me please!

Answer 1

It's not very clear what it should look like.
Oracle java stored procedures: https://docs.oracle.com/cd/B19306_01/java.102/b141...
Apparently you need something like this but with elliptic curves: https://docs. oracle.com/cd/B19306_01/network.102/b... and the list of supported algorithms does not contain the required one. Maybe you should consider doing without elliptic curves and use the standard solution?
And if you crutch ... then, for example, you can access tables only through views, in the views on each encrypted column, hang the decryption function, this will solve the selection problem, and solve the insertion problem instead of with a trigger on the view ( https://docs .oracle.com/cd/B10500_01/server.920/a9...in which to encrypt the desired values ​​and insert into the desired tables. And, with this approach, however, as with the standard solution, there will be problems with selecting encrypted columns.