Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

PLS-00103: End of File Error

user517674Feb 24 2011 — edited Feb 24 2011
When I run this PL / SQL block I get a
ORA-06550: line 4, column 54:
PLS-00103: Encountered the symbol "end-of-file" when expecting one of the following:

;
DECLARE
   CURSOR tmp_cur
   IS
      SELECT column_name FROM schema_name.table_name;
BEGIN
   FOR tmp_add_cur IN tmp_cur
   LOOP
      EXECUTE IMMEDIATE tmp_add_cur.column_name;
   END LOOP;
END;
Tried removing the ‘;’ and I get whole bunch of error messages. I am able to execute this fine in toad though.

Any suggestions?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 24 2011
Added on Feb 24 2011
11 comments
2,066 views