Having problems creating a function or procedure

When I try to create functions or procedures sqlplus just hangs.
I have tried creating several function and procedures written in the
developing pl/sql manual. The 1st procedure I created worked. All the others will not compile. Any ideas on the problem?
ReneeHello,

could it be, that the procedures is still in creation status by another process - or it is running ?

Just an idea

Regards
Manfred Peter
(Alligator Company)
http://www.alligatorsql.com

Hangs on Applying Computer Settings

I have 2 nodes Cluster Active/Passive on Windows 2003. When I reboot either
one, it comes fast no problem but when I logon to the node it takes 15
minutes waiting on "Applying Computer Settings" message then it will show
the desktop.
I didn't install SQL 2000 yet, I need to solve this issue before I install
it.
Does any one have this issue that it takes so long to logon?
Thanks
Ayad
Sounds like a service start issue. Check your system event log to see if
any services are hanging on startup. BITS is one I typically have problems
with. Setting it to manual startup seems help.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Ayad" <ashammout1@.hotmail.com> wrote in message
news:eU0BdXBzEHA.352@.TK2MSFTNGP14.phx.gbl...
> I have 2 nodes Cluster Active/Passive on Windows 2003. When I reboot
either
> one, it comes fast no problem but when I logon to the node it takes 15
> minutes waiting on "Applying Computer Settings" message then it will show
> the desktop.
> I didn't install SQL 2000 yet, I need to solve this issue before I install
> it.
> Does any one have this issue that it takes so long to logon?
> Thanks
> Ayad
>