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_at_posting.google.com>
Date: 6 Feb 2004 14:10:20 -0800
Message-ID: <6554b826.0402061410.7355e091_at_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
declare
end; -- <<< causes error!! any idea
end;
ERROR at line 5:
begin
begin
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
<a single-quoted SQL string> pipe
Thanks in advance,
Mourad Received on Fri Feb 06 2004 - 23:10:20 CET