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 ?