Java and JavaScript in the Database

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Java Stored Procedure vs. PL/SQL

415730Feb 26 2004 — edited Mar 10 2004

I have to write an application on a DB Oracle 8.1.6. This application consists of several stored procedure which get a lot of data from DB, do a lot of calculations and write a lot of data to the DB.
I have to do this choice in terms of run-time performance: writing those stored procedure in Java Stored Procedure or in PL/SQL? Is it possible (without not much problems) to compile in native code (with NCOMP) the Java Stored Procedure to obtain a better performance?
Is there anyone who is experienced with this one?
Thank you very much!

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 7 2004

Added on Feb 26 2004

3 comments

319 views