Solved

help with FORMS_DDL statement in FORMS v4.5

Posted on 2001-06-15
1
1,253 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 2

Accepted Solution

by:
renuraj earned 50 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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Suggested Solutions

How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.
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
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

752 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