Delare

[mohamed mousa]

CURSOR emp_cur IS
SELECT Sl_CODE,SL_DESC FROM SLCODE
WHERE gl_CODE = :Fgl_CODE ;
OPEN emp_cur;
LOOP
FETCH emp_cur
INTO VSl_CODE,VDESC1 ;
EXIT WHEN emp_cur%NOTFOUND;
END LOOP;
CLOSE emp_cur;
دة الاصل فى الجملة التى لدى
اريد اخوانى الاعزاء جزاكم اللة كل خير ان اعمل الاتى ساعدونى ساعدكم اللة
var varchar2(500):='SELECT Sl_CODE,SL_DESC FROM SLCODE
WHERE gl_CODE = :Fgl_CODE ';

CURSOR emp_cur IS var;
OPEN emp_cur;
LOOP
FETCH emp_cur
INTO VSl_CODE,VDESC1 ;
EXIT WHEN emp_cur%NOTFOUND;
END LOOP;
CLOSE emp_cur;