Unanswered: calling a procedure - it shuts down service
I have created a few stored procedure in which i have used cursors. Those procedures are working fine until i call one procedure from other.
say there is a procedure name proOne(@aString). which gets a varchar. Depending on the string, it first get values from one table (using cursor) and then for each cursor value it selects value from other table. suppose it return 3 rows.
Now i am calling the procedure "proOne()" from another procedure say proTwo. When i call it ... it halts the system and if somehow it don't it shut down the service. i am unable to get what the problem is here.
Can you tell me the expected mistakes that i am doing ?