PL/SQL (MOSC)

MOSC Banner

PLS-00103: Encountered the symbol "EXCEPTION"

in PL/SQL (MOSC) 5 commentsAnswered ✓

Hi,

on 11.2.0.4 , I ran

DECLARE 

  i number(1); 

  j number(1); 

BEGIN 

    FOR j IN 1..3 LOOP 

     dbms_output.put_line('i is: '|| i || ' and j is: ' || j); 

     exception

     when others then

     null;

   END loop ; 

  END; 

/

And I had:

Error report -

ORA-06550: line 9, column 10:

PLS-00103: Encountered the symbol "EXCEPTION" when expecting one of the following:

  ( begin case declare end exit for goto if loop mod null

  pragma raise return select update while with <an identifier>

  <a double-quoted delimited-identifier> <a bind variable> <<

  continue close current delete fetch lock insert open rollback

  savepoint set sql execute commit forall merge pipe purge

06550. 00000 - "line %s, column %s:\n%s"

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center