hi how to display error message in oracle forms
i used this code on button event when button pressed trigger
FORMS_DDL('CREATE USER '||:USER.USERNAME||' IDENTIFIED BY '||:USER.PASSWORD);
FORMS_DDL('GRANT CREATE SESSION TO '||:USER.USERNAME);
i want to display error message when user leave username and password field and and value in this field are null then it show error message and not execute code that i mention above !!!
and i don't want to use required field set to true i want to code on plsql