Re: Nested blocks in PL/SQL

From: Mourad <mourad_barakat_at_yahoo.com>
Date: 9 Feb 2004 07:45:26 -0800
Message-ID: <6554b826.0402090745.1fa0b6c5@posting.google.com>

Mark, you are right.. here is a paste from the sqlplus screen:

SQL> declare
  2
  3 begin
  4
  5 declare
  6
  7 begin
  8
  9 end;
 10
 11 end;
 12 /

        end;
        *

ERROR at line 9:
ORA-06550: line 9, column 2:
PLS-00103: Encountered the symbol "END" 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

SQL> Thanks,
Mourad

"Mark C. Stock" <mcstockX_at_Xenquery .com> wrote in message news:<86-dnbmYwfhMwbndRVn-jg_at_comcast.com>...
> "Mourad" <mourad_barakat_at_yahoo.com> wrote in message
> news: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
> | 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
>
> you'll need to post the actual code that caused the error, what you posed
> does not show what is actually happening (ie, the error is on EXCEPTION, you
> have no EXCEPTION in what you posted)
Received on Mon Feb 09 2004 - 09:45:26 CST