Re: Why use Java Stored Procedures....

From: Rauf Sarwar <rs_arwar_at_hotmail.com>
Date: 1 Mar 2006 02:56:00 -0800
Message-ID: <1141210559.988961.178250@p10g2000cwp.googlegroups.com>

Miggins wrote:
> OK short question but probably not a quick answer....anyone give me the
> pros and cons of using Java for my stored proedures instead of PLSQL.
>
> Thanks In Advance

"If you cannot do it in PL/SQL only then do it in Java". Java is not a replacement for PL/SQL... I consider it just as a good add-on which can be used when you want to do something which maybe cumbersome in PL/SQL. e.g. File IO... things like list files in a directory, delete files, create directory etc.

If you can easily do it in PL/SQL then there is no comparison.

Regards
/Rauf Received on Wed Mar 01 2006 - 04:56:00 CST