Hi how about Java within Oracle. What do you think about it ? When does it make sense to use Java instead of PL/SQL ? The problem is that I dislike a mix of different languages within an application. It messes things up. But maybe it makes sense to use PL/SQL for most stuff and Java for some specific things (perhaps accessing a file or using a network resource ?). As far as I know, there is an option to compile the Java into platform dependend code, which would make it execute much faster then bytecode (and PL/SQL?), since the later has to be interpreted at run-time.
Any opinions ? Regards, -----Ursprüngliche Nachricht----- Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Gesendet: Dienstag, 30. April 2002 16:09 An: Multiple recipients of list ORACLE-L Betreff: Re:pl/sql is INTERPRETED? Lisa, It is both true & false at the same time. Obviously any anonymous blocks you submit to the database are fully interpreted. PL/SQL that you store in the database as procedures, functions, and packages get partially compiled into a p-code. This makes the code ready for execution, but retains a modular design so that if your DBA reloads catproc your code is not totally destroyed. Where I think PL/SQL buys us a lot of performance is in reducing the communications outside of the database that is otherwise needed. There's no JDBC driver or other miscellaneous mess (like SQL*Net) required. It's all handled inside the kernel. Now the bad part about PL/SQL that Java handles better is platform independence. You can run Java on your client, the apps server or database without a problem. PL/SQL on the other hand must be run in the database. Dick Goulet ____________________Reply Separator____________________ Author: "Koivu; Lisa" <[EMAIL PROTECTED]> Date: 4/29/2002 2:52 PM Can this be true? How can this be? If it's optimized to manipulate data within the database, how can it be fast if it's interpreted (like that slow poke, Java)? I see this on Connor's website www.oracledba.co.uk under explicit/implicit cursors, under pl/sql. What on earth? Can someone elaborate, namely, Connor?? Please help me understand this... My "green" may be showing, but my gosh. Lisa Koivu Oracle Database Baby Oven Fairfield Resorts, Inc. 5259 Coconut Creek Parkway Ft. Lauderdale, FL, USA 33063 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Koivu, Lisa INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stefan Jahnke INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
