Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.oracle -> Nested blocks in PL/SQL

Nested blocks in PL/SQL

From: Mourad <mourad_barakat_at_yahoo.com>
Date: 6 Feb 2004 14:10:20 -0800
Message-ID: <6554b826.0402061410.7355e091@posting.google.com>

Hi all,

This is an example of a nested block, however it seems Oracle doesn't like the syntax. see the error below:

declare
begin

    declare
    begin

    end; -- <<< causes error!! any idea end;

ERROR at line 5:
ORA-06550: line 5, column 7:
PLS-00103: Encountered the symbol "EXCEPTION" when expecting one of the
following:
begin case declare exit for goto if loop mod null pragma raise return select update while with <an identifier>
<a double-quoted delimited-identifier> <a bind variable> <<
close current delete fetch lock insert open rollback savepoint set sql execute commit forall merge
<a single-quoted SQL string> pipe

Thanks in advance,

Mourad Received on Fri Feb 06 2004 - 16:10:20 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US