Calling Java classes from PL/SQL

[Jimmy Dee Ramoe]

Hello,

Does anyone know if there is a possibility to call Java classes in J2EE application server from PL/SQL stored procedures?

I have a situation where I would like to offer a interface to third party vendor via PL/SQL and then offer an Java interface to standard J2EE clients using those same Java classes (like facade to service).

Has anyone any experince considering this kind of issue?

Cheers

[Mark Spritzler]

This really isn't the right forum for this question, as it is an Oracle question and not a J2EE question.

Since you can use a Java class as a stored procedure, then you should be able to do something from there. Once you are in the Java class you should be able to do whatever any other Java class can do. Which should include doing a remote lookup for an EJB and calling it.

Moving this to the Oracle forum.

Mark

[Jimmy Dee Ramoe]

Actually found myself a answer finally.
Proper way in my case is to use sql: create directory and put java files
there. PLSQL can can use Java classes that resides in disk's directory.
And those classes are visible to ordinary OC4J WebApps too.