Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

help with FORMS_DDL statement in FORMS v4.5

Posted on 2001-06-15
1
Medium Priority
?
1,516 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

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Question has a verified solution.

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

Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
Introduction A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
Suggested Courses
Course of the Month14 days, 13 hours left to enroll

577 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