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

Thread: doubt in exception and trigger,,, please help

  1. #1
    Join Date
    Mar 2006
    Posts
    1

    doubt in exception and trigger,,, please help

    how to solve this exception problem ?? please help

    Begin
    STMT 1;(im-material if this stmt is executed)
    STMT 2;(but this stmt shud be executed)

    EXCEPTION
    when NO_DATA_FOUND then
    raise_app_error(err.num,err.mesg);
    END

    how do i get the STMT 2 stmt to get executed.if suppose STMT 1 gives error.

    also how many maximum number of trigger can a table have ?

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    put it in the exception clause

  3. #3
    Join Date
    Jun 2005
    Location
    London, UK
    Posts
    159
    Code:
    BEGIN
        BEGIN
            stmt1;
        EXCEPTION
            WHEN no_data_found THEN NULL;
        END;
    
        stmt2;
    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