Nested blocks in PL/SQL

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