Problem loop to dataset

Question
1

How do dataset call to other dataset row same cursor to procedure?

2

Can you please describe the issue in bit more detail ?

3

How do

CREATE PROCEDURE Sample01
IS
str1 VARCHAR(20);
str2 INTEGER;
str3 INTEGER;
CURSOR sample_cur IS
SELECT empid,
ename,
deptid
FROM emp1;
BEGIN
OPEN sample_cur;
…

FETCH sample_cur INTO str2, str1, str3; 

    CLOSE sample_cur; 
END;