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:

            UPDATE TABLE2 SET EMPNO = "X3333-";
             commit; ');

I can't get it to work.   Where am i going wrong ?
Who is Participating?
renurajConnect With a Mentor Commented:
Try as shown below
FORMS_DDL ('UPDATE TABLE1 SET EMPNO = '||''''||'W3333-'||''''||';');
FORMS_DDL ('commit;')
FORMS_DDL ('UPDATE TABLE2 SET EMPNO = '||''''||'X3333-'||''''||';');
FORMS_DDL ('commit;')

Commit statement after the first update is not required, no problem if we issue commit after every dml statement.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.