DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: exception handling

  1. #1
    Join Date
    Oct 2002
    Posts
    109

    exception handling

    hi,
    There is a parent block.It is having two inner blocks(child block),
    If an exception is not caught in childblock1 then the control should go to the exception in the childblock2.
    How can be this done?


    regards!

    Praveen sharma

  2. #2
    Join Date
    Feb 2005
    Posts
    158
    You'll need to nest childblock1 within childblock2. something like
    BEGIN
    --parent block
    BEGIN
    --outer block (child block 2)
    BEGIN
    --child block1
    EXCETPION --for child block 1
    END;
    EXCEPTION --for outer block/child block 2
    END;
    EXCEPTION --for parent block
    END;

Posting Permissions

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


Click Here to Expand Forum to Full Width