Loop

Dúvidas, dicas e truques de PL/SQL. Aqui também vão assuntos relacionados a pacotes, triggers, funções, Java-Stored Procedures, etc
  

Poston Mon, 06 Mar 2006 5:33 pm

Anyone know mi tell you how do not to stop a loop.
Example: I have a loop in a procedure and oa do an insert, fires the trigger from the table where it's being done the insert. wanted the raise doesn't seems the loop.
mello
Location: sp

Poston Mon, 06 Mar 2006 11:50 pm

You can put an exception to capture the error ...

Something like this:
Code: Select all
LOOP
  BEGIN
    PRC_SUA_PROC(PARAM...);
  EXCEPTION WHEN OTHERS THEN NULL;  --> captura todos erros
  END;
  ... etc...
END LOOP;
was that?
dr_gori
Location: Portland, OR USA

Thomas F. G

Você já respondeu a dúvida de alguém hoje?
http://glufke.net/oracle/search.php?search_id=unanswered



Return to PL/SQL

Who is online

Users browsing this forum: No registered users and 11 guests