to get total output of oneprocedure into another procedure

[kiransurisurisetty]

Hi guys
i have created one procedure1 and i am trying to call the procedure1 into procedure2 ,and i got only one row result set from procedure1 but i am unable to get total out put of the procedure1 if anybody now's please suggest me how get retrieve total output one procedure1 into procedure2