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