Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2003

    Unanswered: validation trigger in oracle reports

    can any one guide me how to write a validation trigger in oracle report and in what circumstances we may need to write a validation trigger and can you suggets some good documentaion on it.

    thanx in advance

  2. #2
    Join Date
    Jan 2004
    Croatia, Europe
    Provided Answers: 5
    Write them the same way you'd write any other trigger. If you click onto the "Validation Trigger" button (it appears only on report parameters properties list), you'll see that it offers you to write a function that returns a Boolean (true or false).

    Body of the function depends on the parameter. For example, if you expect that user should enter a number less than 5, trigger would be something like

    if :par_value > 5 then
    return (false);
    return (true);
    end if;

    In that way, if user enters (let's say) 7, trigger will fail and the user will be prompted that the parameter input was invalid.

Posting Permissions

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