Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> RE: pl/sql engine doubt

RE: pl/sql engine doubt

From: Gogala, Mladen <>
Date: Mon, 24 Mar 2003 10:07:00 -0500
Message-Id: <>

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 [] 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". /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."

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


Do you Yahoo!?
Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop!
Please see the official ORACLE-L FAQ:
Author: sam d

Fat City Network Services    -- 858-538-5051
San Diego, California        -- Mailing list and web hosting services
To REMOVE yourself from this mailing list, send an E-Mail message
to: (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
Received on Mon Mar 24 2003 - 09:07:00 CST

Original text of this message