Results 1 to 3 of 3

Thread: Exceptions

  1. #1
    Join Date
    Feb 2003
    Location
    Ontario, Canada
    Posts
    19

    Unanswered: Exceptions

    How do I code an exception to terminate a transaction?
    How do I code an exception so that it doesn't terminate the program?

  2. #2
    Join Date
    Jul 2001
    Location
    Germany
    Posts
    189

    Exception Handling

    Hello,

    If you want to stop a transaction via exception handling or with other techniques, use something like this

    .
    .
    .
    WHILE cuCursor%FOUND LOOP
    EXIT WHEN cuCursor.field = 'exit'
    END WHILE;

    or

    WHILE cuCursor%FOUND LOOP
    IF cuCursor.field = 'exit'
    GOTO EndLabel
    END IF;
    END WHILE;

    <<EndLabel>>
    .
    .
    .

    or

    WHILE cuCursor%FOUND LOOP
    IF cuCursor.field = 'exit'
    THROW endException
    END IF;
    END WHILE;

    If your want to catch a exception use something like this

    WHILE cuCursor%FOUND LOOP
    BEGIN
    nNumber = 'abc';
    EXCEPTION
    WHEN OTHERS THEN
    NULL;
    END;
    END WHILE;


    Hope that helps ?

    Manfred Peter
    (Alligator Company GmbH)
    http://www.alligatorsql.com

  3. #3
    Join Date
    Feb 2003
    Location
    Ontario, Canada
    Posts
    19

    Re: Exceptions

    Thank you, it helped


    Originally posted by bbk
    How do I code an exception to terminate a transaction?
    How do I code an exception so that it doesn't terminate the program?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •