PL/SQL - Encountered the symbol ";"
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';