Re: Exception problem

From: Gjlinker <gjlinker_at_aol.com>
Date: 07 Feb 1999 09:22:38 GMT
Message-ID: <19990207042238.11568.00000377@ngol03.aol.com>

Dear all,

> Is there any way to carry on processing the code after > detecting an exception ?

Yes there is. Embed your code in an extra begin and end block and code an exception clause. For example:

procedure test ( i in number)
as

    j number;
    k number;
begin

    j := i * 10;

    begin

        k := 5/j;
    exception
    when others then

        --an error occurred.
        k := 0;

    end;

    --continue with other statements
end;

Regards Gerrit-Jan Linker,

---

*| Gerrit-Jan Linker : gjlinker_at_aol.com
*|
*| http://members.aol.com/gjlinker
*|
*| Developer of:
*| Oraxcel, OraWeb, OraSQL, OraCodes and OraDebug

---

LLLL      IIII  TTTTTTTTTTTT
LLLL      IIII  TTTTTTTTTTTT
LLLL      IIII      TTTT
LLLL      IIII      TTTT
LLLL      IIII      TTTT
LLLL      IIII      TTTT
LLLL      IIII      TTTT
LLLL      IIII      TTTT
LLLL      IIII      TTTT

LLLL

LLLLLLLLLLLLLLLLLLLLLLLLLLLL

L Linker IT Consulting Ltd L

LLLLLLLLLLLLLLLLLLLLLLLLLLLL

Received on Sun Feb 07 1999 - 03:22:38 CST