dbTalk Databases Forums  

Re: Convert Oracle stored procedure to Java

comp.databases.oracle.tools comp.databases.oracle.tools


Discuss Re: Convert Oracle stored procedure to Java in the comp.databases.oracle.tools forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Pete Finnigan
 
Posts: n/a

Default Re: Convert Oracle stored procedure to Java - 08-01-2003 , 05:32 AM






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 (DOT) google.com>, Prakash
<venkatprakash (AT) hotmail (DOT) com> writes
Quote:
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
emailete (AT) petefinnigan (DOT) 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.


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.