Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Exception raised in a loop

Exception raised in a loop

From: valigula <valigula_at_gmail.com>
Date: 18 Apr 2007 04:44:12 -0700
Message-ID: <1176896652.656740.201420@y5g2000hsa.googlegroups.com>


Hi , Is it possible to raised a exception inside a loop in oracle 9i??

   PROCEDURE somprocedure (resultado OUT generic_cursor)    IS

      tmp                 INTEGER;
      tmp_2               INTEGER;
      stringsql           VARCHAR (3000);
      CURSOR movimientosprimero
      IS
         SELECT DISTINCT *
                    FROM sometable
                   WHERE tipo_mov <> 'B';
   BEGIN
      FOR regfichero IN movimientosprimero
      LOOP

.................
.................
COMMIT; exception when others then return; END LOOP;
Received on Wed Apr 18 2007 - 06:44:12 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US