Thursday, July 2, 2015

Oracle forms FORMS_DDL

when you want to use sql statement in forms, you have to use forms_ddl 

example:

Forms_DDL('truncate table employee');
IF NOT Form_Success then
     Message('Truncate Employee Faled');
END IF;

Forms_DDL('drop sequence esr_emp_id_s;');
IF NOT Form_Success then
     Message('Drop esr_emp_id_s Faled');
END IF;

Forms_DDL('create sequence esr_emp_id_s nocache;');
IF NOT Form_Success then
     Message('Create esr_emp_id_s Faled');
END IF;

No comments:

Post a Comment