Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2004
    Location
    Las Vegas, NV USA
    Posts
    38

    Unanswered: Return from EXCEPTION with NO_DATA_FOUND

    I wrote the following code segments

    SELECT user_login
    INTO :TD_CARS.NTB_USER
    FROM ST_ROLE_PLAYERS
    WHERE role_id = :TD_CARS.NTB_ROLE
    AND user_login =:PARAMETER.p_user
    AND status = 'A';

    IF :TD_CARS.qa_accept = 'A' OR :TD_CARS.qa_accept = 'C' then

    Later in the script....

    /*
    ||
    || EXCEPTIONS
    ||
    */
    EXCEPTION
    WHEN NO_DATA_FOUND
    THEN
    IF :PARAMETER.p_user <> :TD_CARS.RAISED_BY THEN

    al_id2 := Find_Alert('alert_user');
    n2 := Show_Alert('alert_user');
    RAISE Form_Trigger_Failure;
    ELSE
    :TD_CARS.NTB_USER := 'None';
    END IF;
    END;

    I need help in getting the trigger to return to the line of code directly below the SELECT statement after the EXCEPTION is ran. Right now the EXCEPTION runs and stops the form there. THANK YOU!
    Todd Farino
    Timet Corporation
    todd.farino@timet.com

  2. #2
    Join Date
    Jan 2004
    Location
    India
    Posts
    191
    I think this will help you

    declare
    -----
    ------
    begin
    begin
    ------
    ------
    exception
    when no_data_found then
    -----
    -----
    end;
    --control will come here
    end;
    Pagnint
    (No need to search web before posting new question)

  3. #3
    Join Date
    Jan 2004
    Location
    Las Vegas, NV USA
    Posts
    38
    Thank you I will try that.
    Todd
    Todd Farino
    Timet Corporation
    todd.farino@timet.com

Posting Permissions

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