MySQL Oracle PL/SQL - Can one execute dynamic SQL from Forms?

Can one execute dynamic SQL from Forms?

Q

Can one execute dynamic SQL from Forms?

✍: Guest

A

Yes, use the FORMS_DDL built-in or call the DBMS_SQL database package from Forms. Eg:

FORMS_DDL('INSERT INTO X VALUES (' || col_list || ')');

Just note that FORMS_DDL will force an implicit COMMIT and may de-synchronize the Oracle Forms COMMIT mechanism.

2011-04-12, 5384👍, 0💬

How does one suppress or customize error messages in Forms?
How does one suppress or customize error messages in Forms? One can either set the message level using the system variable SYSTEM.MESSAGE_LEVEL or trap errors using the ON-ERROR or ON-MESSAGE triggers. MESSAGE_LEVEL: Set to 0, 5, 10, 15, 20, 25 to suppress all messages with severity below this level... 2011-04-05, 4607👍, 0💬

Can one issue DDL statements from Forms?
Can one issue DDL statements from Forms? DDL (Data Definition Language) commands like CREATE, DROP and ALTER are not directly supported from Forms because your Forms are not suppose to manipulate the database structure. A statement like CREATE TABLE X (A DATE); will result in error: Encountered the ... 2011-04-05, 4183👍, 0💬

Software Test Automation Evaluation Report
Trying to find an Example of a Test Automation Evaluation Report online. It is a report that defines the feasibility of using an automated testing tool to test software. Should be about 2-4 pages basically saying whether testing would be worth the Time/Money. Is there a good example somewhere? 2011-04-14, 3888👍, 0💬

Forms won't allow me to use restricted built-in's. What should I do?
Forms won't allow me to use restricted built-in's. What should I do? How to get around the "can't use a restricted built-in in built-in XXX" message: 1. Create a TIMER at the point where you want the navigation to occur. Eg. create_timer('TIMER_X', 5, NO_REPEAT); 2. Code a WHEN-TIMER-EXPIRED trigger... 2011-04-12, 3625👍, 0💬

All rights in the contents of this web site are reserved by the individual author. fyicenter.com does not guarantee the truthfulness, accuracy, or reliability of any contents.