joekeri
asked on
help with FORMS_DDL statement in FORMS v4.5
on a WHEN-BUTTON-PRESSED, I want to execute 2 SQL UPDATE commands. So in the PL/SQL EDITOR, I created the following code:
FORMS_DDL ('UPDATE TABLE1 SET EMPNO = "W3333-";
commit;
UPDATE TABLE2 SET EMPNO = "X3333-";
commit; ');
I can't get it to work. Where am i going wrong ?
FORMS_DDL ('UPDATE TABLE1 SET EMPNO = "W3333-";
commit;
UPDATE TABLE2 SET EMPNO = "X3333-";
commit; ');
I can't get it to work. Where am i going wrong ?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.