Is possible cursor is using the stored procedure?

Hi, cursor is using the stored procedure?give some examples.

Your question is too much theoritical and is beyond the scope of this discussion. You need to follow some good books on the topic or can easily find all that by investing some time in websearching.