Re: Convert Oracle stored procedure to Java

From: Pete Finnigan <pete_at_petefinnigan.com>
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

Original text of this message