Re: Drop procedure fails??

Gerd Hagmeyer-Gaverus wrote:
>
> It's oracle 8i running on Solaris 2.7
>
> Screamer wrote:
> >
> > What is the oracle version ?
> > What is your platform ?
> >
> > Gerd Hagmeyer-Gaverus <hagmeyer-gaverus_at_sipri.se> wrote in message
> > news:38BD0072.760E2DA1_at_sipri.se...
> > > For some reason one of my procedures seized to work. I tried both 'drop
> > > procedure blabla' and 'replace procedure blabla' but it just makes my
> > > SQL*Plus to hang up.
> > >
> > > I restarted the applications server a couple of times without any result
> > > ther either.
> > >
> > > Has someome any idea how to solve this?
> > >
> > > Gerd
> > >
> > >
> > >
> > >
> > > __________________________________________________________
> > > Gerd Hagmeyer-Gaverus
> > >
> > > Head of the Information Technology Department
> > > Project leader
> > > Integrating fact databases in International Relations and Security
> > >
> > > Stockholm International Peace Research Institute
> > >
> > > Signalistgatan 9
> > > S-169 70 Solna, Sweden
> > > Tel.: +46 - 8 - 655 97 68
> > > Fax.: +46 - 8 - 655 97 33
> > > e-mail: hagmeyer-gaverus_at_sipri.se
> > > SIPRI homepage: http://www.sipri.se
>
> --
> __________________________________________________________
> Gerd Hagmeyer-Gaverus
>
> Head of the Information Technology Department
> Project leader
> Integrating fact databases in International Relations and Security
>
> Stockholm International Peace Research Institute
>
> Signalistgatan 9
> S-169 70 Solna, Sweden
> Tel.: +46 - 8 - 655 97 68
> Fax.: +46 - 8 - 655 97 33
> e-mail: hagmeyer-gaverus_at_sipri.se
> SIPRI homepage: http://www.sipri.se

I would suspect that someone is running the proc whilst you are trying to drop out...Kill of those sessions and give it another whirl..

HTH

-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk

We are born naked, wet and hungry...then things get worse