calling Java from Oracle

[vamsioracle]

hi all


I have few doubts

Can we call a java method from pl sql? if yes how ?
what is JDE?
I want to shift myself from Oracle Apps to JDE ? Is it good.

thank you

[amitpatel66]

Vamsi,

Yes it is ofcourse possible to call a java stored procedure from PLSQL.

If you are registering a Java Stored procedure in oracle applications, select the executable type as Java Stored Procedure.

And when you try to calla java stored procedure, you say something like this:

[code=oracle]

CREATE OR REPLACE PROCEDURE ABC IS LANGUAGE JAVA.....

[/code]

Check for details here