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.
