Oracle-L: AW: pl/sql is INTERPRETED?

From: Stefan Jahnke <Stefan.Jahnke_at_bov.de>
Date: Tue, 30 Apr 2002 06:49:11 -0800
Message-ID: <F001.004534F5.20020430064911@fatcity.com>

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: dgoulet_at_vicr.com [mailto:dgoulet_at_vicr.com] 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" <lisa.koivu_at_efairfield.com>
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: lisa.koivu_at_efairfield.com

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: ListGuru_at_fatcity.com (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: dgoulet_at_vicr.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Stefan Jahnke
INET: Stefan.Jahnke_at_bov.de

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------