Tuesday, 3 February 2015

On-Error Triggger in Form level :- this is common for all form

DECLARE
BEGIN

   IF INSTR(DBMS_ERROR_TEXT, 'ORA-') = 1 AND DBMS_ERROR_CODE <> -1403
   THEN
      frmpkg_export.v_backend_err := 'Y';
   ELSIF  ERROR_CODE = 40401 OR ERROR_CODE = 40102 OR ERROR_CODE = 40405 OR ERROR_CODE = 41051
   THEN
   NULL;
   ELSE
     IF DBMS_ERROR_CODE <> 01403
     THEN
         message(ERROR_TEXT);
      END IF;
   END IF;
   
END;

11 comments:

  1. There are lots of information about oracle have spread around the web, but this is a unique one according to me. The strategy you have updated here will make me to get to the next level in oracle. Thanks for sharing this.

    Oracle Training in Chennai | Oracle Course in Chennai | hadoop training in chennai

    ReplyDelete
  2. Excellent post!!!. The strategy you have posted on this technology helped me to get into the next level and had lot of information in it.
    SAS Training in Chennai | SAS Course in Chennai

    ReplyDelete
  3. Learned a lot of new things from your post ,It's amazing article
    Sql server DBA Online Course Bangalore

    ReplyDelete
  4. "Shri Mintu's Art forayed into the online furniture space as https://shrimintus.com/
    to offer value-for-money furniture made of sheesham wood to Indian consumers.
    The manufacturer and online seller provides finished
    as well as customised products to buyers.
    Enjoy a wide variety of traditional and modern living room furniture with shri Mintus Art."

    Wooden furniture

    ReplyDelete

Copyright © ORACLE-FORU - SQL, PL/SQL and ORACLE D2K(FORMS AND REPORTS) collections | Powered by Blogger
Design by N.Design Studio | Blogger Theme by NewBloggerThemes.com