Error(8,3): PLS-00103: Encountered the symbol "END"
787281Jul 30 2010 — edited Jul 30 2010CREATE OR REPLACE PACKAGE migration
IS
PROCEDURE load_staging_tables;
END migration;
/
CREATE OR REPLACE PACKAGE BODY migration
IS
PROCEDURE load_staging_tables
IS
LAST_CREATE_DATE date;
BEGIN
LAST_CREATE_DATE := select max(migrate_load_dt) from mgur;
END load_staging_tables;
END migration;
/
The following error is received:
Error(8,3): PLS-00103: Encountered the symbol "END"
running in 11g using sql developer.
Whats wrong with the script ?