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