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?