PLS-00103: Encountered the symbol "SQL" ...

wow

anyway the correct way to do that is
exec ERARCH.ER_ARCH.er_arch_and_purge (1) ;

yes.i tried that before, it was giving

SQL> exec ERARCH.ER_ARCH.er_arch.er_arch_and_purge (1);
BEGIN ERARCH.ER_ARCH.er_arch.er_arch_and_purge (1); END;

*
ERROR at line 1:
ORA-06550: line 1, column 7:
PLS-00201: identifier 'ERARCH.ER_ARCH' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

i also granted execute priviledge to sys user

you typed it wrong

sorry i did meant "exec ERARCH.ER_ARCH.er_arch_and_purge (1) ;"

SQL> exec ERARCH.ER_ARCH.er_arch_and_purge (1) ;
BEGIN ERARCH.ER_ARCH.er_arch_and_purge (1) ; END;

*
ERROR at line 1:
ORA-06550: line 1, column 7:
PLS-00201: identifier 'ERARCH.ER_ARCH' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

does the package actually exist - did you create it in the database?

Try select owner, object_type from all_objects where object_name='ER_ARCH'; or just desc ERARCH.ER_ARCH.

If I type in delete press enter and then try to do something different sqlplus will think that the second thing I wanted to do related to the delete command. Commands in sqlplus are terminated with a / or ;.

hmm..it does not seem to be locating the procedure. is there a specify path i need to put the script at? at the moment, i am just putting in for example, /orcl/erarch and from there i login to sqlplus.

SQL> select owner, object_type from all_objects where object_name='ER_ARCH'
2 ;

no rows selected

SQL> desc ERARCH.ER_ARCH
ERROR:
ORA-04043: object ERARCH.ER_ARCH does not exist

So it might exist, but you don't have execute privilege on it. Do you have a dba that could help you run this? You mist otherwise how would you get the database?

Quote:

---

Originally Posted by pigggy

hmm..it does not seem to be locating the procedure. is there a specify path i need to put the script at? at the moment, i am just putting in for example, /orcl/erarch and from there i login to sqlplus.

SQL> select owner, object_type from all_objects where object_name='ER_ARCH'
2 ;

no rows selected

SQL> desc ERARCH.ER_ARCH
ERROR:
ORA-04043: object ERARCH.ER_ARCH does not exist

---

i am the having the database (installed and controlled by me entirely) in my laptop with two sql script that has the procedure.

i granted the execution priviledge to sys. i am connected with sqlplus / as sysdba;

and from there i am executing the package and gave me the error below. i know the scripts work because it is in production now.

have you created the package in the database - yes or no

SQL scripts sitting on your laptop are irrelevant

yes.i have moved on by created the package and the body. and a new user with erarch.
now.. i have warning :compilation error ..

it complained certain table and view not exist, i dont think i can ignore the warning..

well not really, you need to make sure the tables exist