| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: pl/sql engine doubt
Let me throw some shade onto the issue:
a) PL/SQL engine does not execute SQL statements - ever. It passes them
over to the SQL Executor engine.
b) PL/SQL is just a procedural enclosure of the SQL language. There is
another one: it's called Java.
c) Procedural part can be parsed either by an application tool or oracle
kernel. The thing to watch for is the version of the PL/SQL engine embedded in the application tool. The ideal situation is when these two versions are the same. If they are not, life can get interesting.
-----Original Message-----
From: sam d [mailto:sam_orafan_at_yahoo.com]
Sent: Monday, March 24, 2003 4:29 AM
To: Multiple recipients of list ORACLE-L
Subject: pl/sql engine doubt
Hi List,
I was going thru Oracle "PL/SQL User's Guide and
Reference".
http://otn.oracle.com/docs/products/oracle9i/doc_library/release2/appdev.920
/a96624/01_oview.htm#962
Paragraphs below (near the "Figure 1-4 PL/SQL Engine" in the doc) confused me little.
para1 ---
"These two environments are independent. PL/SQL is
bundled with the Oracle server but might be
unavailable in some tools. In either environment, the
PL/SQL engine accepts as input any valid PL/SQL block
or subprogram. Figure 1-4 shows the PL/SQL engine
processing an anonymous block. The engine executes
procedural statements but sends SQL statements to the
SQL Statement Executor in the Oracle server."
para2--
"In the Oracle Database Server:
Application development tools that lack a local PL/SQL
engine must rely on Oracle to process PL/SQL blocks
and subprograms. When it contains the PL/SQL engine,
an Oracle server can process PL/SQL blocks and
subprograms as well as single SQL statements. The
Oracle server passes the blocks and subprograms to its
local PL/SQL engine."
Now my doubt is:
1.In para1 - Does pl/sql engine only processes
the procedural statements and always passes SQL
statements to SQL Statement Executor ?
2.In para2 sentence "When it contains ..." says Oracle pl/sql engine can process SQL statements.
Statements in both paragraphs seems ambiguous. Pls shade some light.
Thanks
Sam
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: sam d INET: sam_orafan_at_yahoo.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- 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 mayReceived on Mon Mar 24 2003 - 09:07:00 CST
 |
 |