Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

help with FORMS_DDL statement in FORMS v4.5

Posted on 2001-06-15
1
Medium Priority
?
1,457 Views
Last Modified: 2008-02-01
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 ?
0
Comment
Question by:joekeri
1 Comment
 
LVL 2

Accepted Solution

by:
renuraj earned 200 total points
ID: 6195653
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.

Regards,
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Working with Network Access Control Lists in Oracle 11g (part 2) Part 1: http://www.e-e.com/A_8429.html Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access.  For many‚Ķ
Shell script to create broker configuration file using current broker Configuration, solely for purpose of backup on Linux. Script may need to be modified depending on OS-installation. Please deploy and verify the script in a test environment.
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.
Suggested Courses

963 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question