반품
-
제목
Setting two conditional break points -
설명
SQL Navigator
Setting two conditional break points on a fetched cursor will not stop at a break point. -
해결 방안
Example:
BEGIN
OPEN c_students;
LOOP
FETCH c_students INTO v_studentid, v_FirstName, v_LastName; --break point here.
EXIT WHEN c_students%NOTFOUND;
END LOOP;
You can set a single conditional break point on either temp variables, but cannot have two defined conditional break points on a fetched cursor.
WORKAROUND
The workaround is to define one conditional break point on a fetched cursor.
STATUS
This issue has been submitted to our development group and it is listed on enhancement list. Software limitation, at this time.