uib$email.msend(mailto => :mailto,
                  subject => :subject,
                  message => :message,
                  mailfrom => :mailfrom,
                  mimetype => :mimetype,
                  priority => :priority);

exists (sql query returns at least one row)
NOT Exsts(SQL query retrns no rows)
SQL Expression
PL/SQ Expression
PL/SQL Fuction Body Return a Boolean
Request=Expression 1
Request!=Expression 1
Request is Contained within Expression 1
Request is NOT Contained within Expression 1
Value of item/ Column in Expression 1 = Expression 2
Value of item/ Column in Expression 1 != Expression 2
Value of item/ Column in Expression 1 is NULL
Value of item/ Column in Expression 1 is NOT NULL
Value of item/ Column in Expression 1 = Zero
Value of item/ Column in Expression 1 != Zero
Value of item/ Column in Expression 1 is NULL or Zero
Value of item/ Column in Expression 1 is NOT NULL and the item is NOT Zero
Value of item/ Column in Expression 1 Contains No Space
Value of item / Column in Expression 1 is Numeric
Value of item / Column in Expression 1 is NOT Numeric
Value of item / Column in Expression 1 is Alhanumeric
Value of item / Column in Expression 1 is Contained within Colon Delimites List in Expression 2
Value of item / Column in Expression 1 is NOT Contained within Colon Delimites List in Expression 2
Value of User Preference i Expression 1 = Expression 2
Value of User Preference i Expression 1 != Expression 2
Current page = Expression 1
Current page != Expression 1
Current page is Contained Within Expression 1 (comma delimited list of pages)
Current page = age Submittes (this page was posted)
Current page = age Submittes (this page was not the page posted)
Current page is in Printer Friendly Mode
Text in Expression 1 is Contained in Value of item / Columnin Expression 2
Text in Expression 1 is Contained within the Text in Expression 2
Text in Expression 1 is NOT Contained within the Text in Expression 2
Text in Expression 1 = Expression 2 (includes &ITEM substitutions)
Text in Expression 1 != Expression 2 (includes &ITEM substitutions)
User is Authentivates (not public)
User is the Public User (user has not athenticated)
inline Validation Errors Displayed
No inline Validation Errors Displayed
SQL Reports (OK to show the forward button)
SQL Reports (OK to show the back button)
Client Browser: Mozilla/ Netscape 6.x/7.x or higher
Client Browser: Microsoft Internet Explorer 5.5 6.0 or higher
Client Browser: XHTML / CSScapable browser
Client Browser: Other browsers (or older version)
Current Language is Containes wihin Expression 1
Current Language is NOT Containes wihin Expression 1
Current Language != Expression 1
Current Language = Expression 1
When CGI_ENV DAD_NAME = Expression 1
When CGI_ENV DAD_NAME != Expression 1
When CGI_ENV SERVER_NAME = Expression 1
When CGI_ENV SERVER_NAME != Expression 1
When CGI_ENV HTTP_HOST = Expression 1
When CGI_ENV HTTP_HOST != Expression 1
When CGI_ENV DAD_NAME = Expression 1
When CGI_ENV DAD_NAME != Expression 1
When CGI_ENV SERVER_NAME = Expression 1
When CGI_ENV SERVER_NAME != Expression 1
When CGI_ENV HTTP_HOST = Expression 1
When CGI_ENV HTTP_HOST != Expression 1
Never
Always

Allwys Null
Static Assignment (value equals source attribute)
SQL Query (return single value)
SQL Query (return colon separated value)
Item (aplication or page item name)
PL/SQL Expression or Function
PL/SQL Function Body
Database Column
Preference

if проверка_входных_хранимке then
begin
  raiseApplicationError mmmmmmmmmmmmmmmmmm
end

if проверка_входных_хранимке then
begin
  raiseApplicationError mmmmmmmmmmmmmmmmmm
end

create or replace procedure r_proc (i integer)
is
       er01 exception;
begin
  if i=1 then
    raise er01;
    end if;
exception
  when er01
    then dbms_output.put_line ('Проверка');
end;

begin
  uib2.r_proc(1);
end
;

uib2.r_proc(1);

create or replace procedure r_proc (i integer)
is
       er01 exception;
begin
  if i=1 then
    raise er01;
    end if;
exception
  when er01
    then 
      apex_application.G_GLOBAL_NOTIFICATION:='Ошибка глобальная';
      apex_application.G_NOTIFICATION:='Проверка';
end;

create or replace procedure r_proc
begin
raise_application_error(-20500, 'бла бла');
end;

create or replace procedure R_PROC
is
begin
  raise_application_error(-20500, 'бла бла');
end;

create or replace procedure R_PROC
is
begin
  raise_application_error(-20500, 'бла бла');
end;

begin
  :P1_MESS_FROM_DA := '';
  хранимка(); // в БД Exception
EXCEPTION
  WHEN others THEN
   :P1_MESS_FROM_DA := 'ssssssssssssssssss';
END;

begin
  :P1_MESS_FROM_DA := '';
  хранимка(); // в БД Exception
EXCEPTION
  WHEN others THEN
   :P1_MESS_FROM_DA := 'ssssssssssssssssss';
END;

begin
  :P1_MESS_FROM_DA := '';
  хранимка(); // в БД Exception
EXCEPTION
  WHEN others THEN
   :P1_MESS_FROM_DA := 'ssssssssssssssssss';
END;

delete from Table_test where id=:P10_ID;

delete from Table_test where id=:P10_ID;