Call Java Cryptography Architecture (JCA) from PL/SQL

Is it possible to access (call) Java Cryptography Architecture (JCA) classes开发者_运维问答 from PL/SQL? For example, when stored procedure are running.

P.S. The big task is to validate digital signature (RSA) in PL/SQL.

First of all, have you looked at the DBMS_CRYPTO package in Oracle? If that supports the algorithm(s) you need, I would suggest using it instead of calling Java.

But yes, if necessary, you should be able to call JCA from PL/SQL. It looks to me like this is part of the core JDK and therefore should be included in the Oracle built-in Java environment already, but even if that were not the case you could load the classes into the database yourself. The only major limitation is that you can't utilize JNI within the database, but I think that's not relevant in this case.

If your question is more generally how to call Java from PL/SQL, then start with the Oracle Java Developer manual. The chapter on Java Stored Procedures is primarily what you need.