Can a stored procedure call another stored procedure?
Yes. The stored procedure being called is referred to as being nested.
How do I execute a cursor?
Simply use the OPEN CURSOR statement. This sends the results of the cursor to a staging area.