Saturday, 7 February 2015

undefined undefined
Bulk Collect In Oracle Definition of Bulk Collect:- Bulk binds can improve the performance when loading collections from a queries. The BULK COLLECT INTO construct binds the output of the query to the collection. To test this create the following table. below example will help you to understand how it will improve performance. create a table to understand how bulk...

Tuesday, 3 February 2015

undefined undefined
On-Message Trigger form level in oracle form 11g:-  this is common for all form. DECLARE BEGIN        IF MESSAGE_TYPE = 'FRM' AND MESSAGE_CODE = 40400     THEN       IF frmpkg_export.v_user_selected = 'D'        THEN          message('Deleted Successfully', NO_ACKNOWLEDGE);       ELSE  ...
undefined undefined
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;  ...
Copyright © 2025 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