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