Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2012
    Posts
    2

    Unanswered: 100501 non oracle exception in Oracle forms

    I was debugging an oracle form and while trying to submit an invoice through an excel sheet saved in shared folder and when i click on upload button .. it throws me this exception..

    EXCEPTION
    WHEN OTHERS
    THEN
    raise form_trigger_failure;
    END;

    and atlast

    EXCEPTION
    WHEN OTHERS
    THEN
    message ('Error code ' ||SQLCODE|| 'Error message '||SQLERRM);
    raise form_trigger_failure;
    END;

    Please confirm if this is the cause of error.. if so.. please let me know the alternative for this. Thanks!!

  2. #2
    Join Date
    Sep 2012
    Posts
    18
    ASSALAM U ALAIKUM

    TRY THIS



    exception
    when OTHER then
    raise_application_error
    (-20001
    , '[YOUR MESSAGE] '
    , true);
    when invalid_manager then
    raise_application_error
    (-20002
    , ''[YOUR MESSAGE] ');

    end;

  3. #3
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

Posting Permissions

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