getting oracle error ora-00103 when I try to execute a package in oracle 10g
The DELETE FROM watersitesyn; code is still in the declarative part of your procedure.
You need to add a BEGIN to end the declarative part and begin the executable part as described in this section of the Oracle 11.2 Database 2 Day Developer's Guide.