Does anyone have any examples of a sql stored proc that uses 2 cursors that passes a host variable from the outer cusor to the inner cursor?

Is the PREPARE/EXEC sql stmt the only way to achieve this? or is there a simpler way?

Thanks,

BK