Pl/SQL and stored Java

Hi!
When should Java stored procedures be used instead of PL/SQL stored procedure? Is there any performance gains using java Stored procedures?

Requirements dicatate sometime that you use stored proceedures in java

take a look at thsi examples................

1) suppose you wnat to get a time to the nearest micro second
then pl/sql cant help you .you need to use java.....

2)suppose you need to execute a host command within your code even in this case you need to use java coz currently you cant execute a host command from pl/sql

there could be many more such examples....probably someone else would post them here

How About Performance?

hi sudip

At my site we dont use java so i am not sure about performance (though i think that java programs are slow )but if you write a java stored proceedure and is stored in the database then i think performance shouldnt be a problem but it requires lots of ram........

Oracle generally recommends using PL/SQL where possible and java where necessary. In part this is due to the ability of Oracle to optimize SQL, and their ability to extend the language to fit identified business needs.

However, java can execute host commands, has better complex-object support and is object oriented.

Here's a link for java stored procedure beginners:

http://www.oracle.com/oramag/oracle/...l?o20java.html

Thanks a lot guys