If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

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.

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?

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.