-
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:
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;
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|