Re: Convert Oracle stored procedure to Java
Date: Fri, 1 Aug 2003 11:32:23 +0100
Message-ID: <VXPZYAB3GkK$EwXN_at_peterfinnigan.demon.co.uk>
Hi
If you want to migrate something written in PL/SQL to Java then i wouldn't, PL/SQL runs faster in the database in general than Java. The main reason being (I think) being that most of PL/SQL actually ends up inside C calls so it running native. If you have 9i and above you can compile your PL/SQL into C and get a performance advantage also.
There was a thread quite sometime back on the performance merits of PL/SQL and Java in the db, search on google in groups and it should come up.
hth
kind regards
Pete
In article <78b3b5e2.0307311843.48d3ae3a_at_posting.google.com>, Prakash
<venkatprakash_at_hotmail.com> writes
>hi
>
>Is there any tool available to convert all the Oracle stored
>Procedures to either Java stored procedure or just java programs.
>
>I appreciate your help
>
>Thanks
>
>V Prakash
-- Pete Finnigan email:pete_at_petefinnigan.com Web site: http://www.petefinnigan.com - Oracle security audit specialists Book:Oracle security step-by-step Guide - see http://store.sans.org for details.Received on Fri Aug 01 2003 - 12:32:23 CEST