PL/SQL (MOSC)

MOSC Banner

PL/SQL - Encountered the symbol ";"

edited Jul 17, 2018 5:01AM in PL/SQL (MOSC) 7 commentsAnswered

Hi,

Below is the following pl/sql and when I run it I get the following error.All my begins and ends line up as well as the end loops I am missing something small but cant seem to find it.

Error report -

ORA-06550: line 25, column 4:

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

   loop

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

*Cause:    Usually a PL/SQL compilation error.

*Action:

declare

oname varchar2(30);

otype varchar2(30);

cursor c1 is select OBJECT_NAME from all_objects where owner='SCOTT';

cursor c2 is select OBJECT_TYPE from all_objects where owner='SCOTT';

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