Home » SQL & PL/SQL » SQL & PL/SQL » PLS-00103: Encountered the symbol "end-of-file" ...
PLS-00103: Encountered the symbol "end-of-file" ... [message #603433] Mon, 16 December 2013 09:48 Go to next message
krishnapb66
Messages: 1
Registered: December 2013
Location: BANGALORE
Junior Member
HI FRIENDS I CANT UNDERSTAND ERROR CAN U FIND
SQL> ED
Wrote file afiedt.buf

  1  DECLARE
  2  A NUMBER(4) :=2;
  3  BEGIN
  4  LOOP
  5  A:=A+1;
  6  EXIT WHEN A>50;
  7  END LOOP;
  8  DBMS_OUTPUT.PUT_LINE(A);
  9* EXIT;
 10  /
EXIT;
    *
ERROR at line 9:
ORA-06550: line 9, column 5:
PLS-00103: Encountered the symbol "end-of-file" when expecting one of the following:
( begin case declare end exception 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


[EDITED by LF: split from an unrelated topic; fixed typos; applied [code] tags]

SQL>

[Updated on: Mon, 16 December 2013 10:37] by Moderator

Report message to a moderator

Re: validate records in nested table [message #603435 is a reply to message #603433] Mon, 16 December 2013 10:00 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
  1   DECLARE
  2   A NUMBER(4) :=2;
  3   BEGIN
  4   LOOP
  5   A:=A+1;
  6   EXIT WHEN A>50;
  7   END LOOP;
  8   DBMS_OUTPUT.PUT_LINE(A);
  9*  END;
SQL> /

PL/SQL procedure successfully completed.

SQL> set serveroutput on
SQL> /
51

PL/SQL procedure successfully completed.

Previous Topic: ORA-20120:ORA-01405:fetched column value is null
Next Topic: Right Outer Join - ORA-01719
Goto Forum:
  


Current Time: Tue Apr 23 07:04:47 CDT 2024