Home / Questions / 5546
Accepted
RubenQs
Asked: 2020-03-11 07:29:33 +0800 CST 2020-03-11 07:29:33 +0800 CST

How to jump to the next iteration of a FOR via PL/SQL exception?

  • 772

I am doing a for loop in Oracle 10g, inside the loop I have a query, what I need is that if this query does not return anything or gives an error, jump to the next iteration without performing the following instructions.

      FOR I IN LTRN.FIRST .. LTRN.COUNT

        LOOP


    SELECT ID_CLIENTE

     INTO VID_CLIENT`introducir el código aquí`E

          FROM AAA_CLIENTES

              WHERE ID_PERSONA = LTRN(I).ID_PERSONA;

                    LTRN(I).ID_CLIENTE := VID_CLIENTE;

/*(Aquí debería ir el "exception" y dentro de este la opción para saltar a la siguiente iteracion del for, intente con Go To pero me generar error)*/


      END LOOP;

I hope you can help me.

plsql

1 Answers

  1. Best Answer

    As I mentioned in the comments, an IF ENDIF block could be used.

     FOR I IN LTRN.FIRST .. LTRN.COUNT
   LOOP

    BEGIN
    SELECT ID_CLIENTE

     INTO VID_CLIENT`introducir el código aquí`E

          FROM AAA_CLIENTES

              WHERE ID_PERSONA = LTRN(I).ID_PERSONA;

                    LTRN(I).ID_CLIENTE := VID_CLIENTE;
           IF NOExisteExeption THEN
               /*Instrucciones a realizar cuando no existe ninguna exeption
                 .
                 .
                 .
                 .*/
         ENDIF;
      END;
/**continua el bucle**/
END LOOP;
    • 0