Cannot use open cursor - fetch - close in a Stored Proc

[Yothepapy]

I want to use a Stored procedure which use an
open CURSOR C1
fetch C1
perform some actions on data of C1
for instance, retrieving data from others tables
close C1

But I don't find a way to.

The only example is Resolution entry 315 from BO
ex: open C1 for select * from Table
But I want to do the upper example -open C1-fetch-close

Help ME

Thanks to everybody