PLS-00103: Encountered the symbol "SQL" ...
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:
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"
PROCEDURE er_arch_and_purge (p_days_offset IN INTEGER);
Click Here to Expand Forum to Full Width