Hi Guys, i am new to oracle and today i was trying to run a exec a procedure in a script but gave me this errors. any ideas/suggest from anyone will be very helpful. many thanks ..


SQL> exec ERARCH.ER_ARCH.sql.er_arch_and_purge (1) ;
BEGIN ERARCH.ER_ARCH.sql.er_arch_and_purge (1) ; END;
*
ERROR at line 1:
ORA-06550: line 1, column 22:
PLS-00103: Encountered the symbol "SQL" when expecting one of the following:
delete
exists prior
The symbol " was inserted before "SQL" to continue.



============
The sql script
============
bash-3.1$ cat ERARCH.ER_ARCH.sql
CREATE OR REPLACE PACKAGE "ERARCH"."ER_ARCH"
AS
PROCEDURE er_arch_and_purge (p_days_offset IN INTEGER);
END Er_Arch;