calling stored procedure inside while loop

[sunshine123]

Hi,

I noticed that in Sql server 2000 it is not possible to call a stored procedure
inside the while loop. I have a while loop similar to the following inside a stored procedure which in turn calls a stored procedure. However an error is thrown.

while (intNumber < 10)
Begin
Exec someStoredProcedure
intNumber = intNumber + 1
End

thanks in advance