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).
