Oracle Recursive procedures

I have a small question on recursive sub programs in Oracle. I have a one procedure xx_FIRST with one parameter. In this procedure at circumstances I need to call the same procedure with different parameter value. There is a IF condition in that, like if that condition is true call yy_SECOND procedure otherwise call same procedure xx_FIRST with different parameter value. These procedures are in same package and does have couple of CURSORS, SELECT and UPDATE statements. This is something related to recursion. But I have used recursion on programming languages like C, Java...etc,. I dont know the recursion will work in Oracle database procedures or not. Does this cause any unending loop? Does it make databse server down for a while when the loop is going on? Will it affect database slow down performance?
 
  I would appreciate if anyone can help me in this issue, Thanks in advance

The sample code is looks like:

PROCEDURE xx_FIRST(
    v_id  IN  NUMBER
) IS
    v_f_sum       NUMBER := 0;

    CURSOR a_cursor IS
        SELECT  distinct ID, NAME
        FROM    EMP
        WHERE   EMP_ID = v_id;

    CURSOR b_cursor IS
        SELECT  distinct ID, NAME
        FROM    DEPT
        WHERE   EMP_ID = v_id;
BEGIN
        FOR C1 IN a_cursor LOOP
          IF ().... END IF;
     END LOOP;

        FOR C2 IN B_cursor LOOP
          IF ().... END IF;
     END LOOP;

     UPDATE EMP
     SET EMP_NAME='TEST';

     COMMIT;

     v_id := v_id + 1;

        IF (v_id != 0)) THEN
            xx_FIRST(v_id);
        ELSE
            yy_SECOND(v_id);
        END IF;
END;Start Free Trial