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...
Saturday, 7 February 2015
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 Trigger in oracle Forms 11g
Posted by Unknown in Oracle
12 comments
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;
...
Subscribe to:
Posts (Atom)