Can one execute dynamic SQL from Forms?

.NET C C++ CSS DBA General HTML Java JavaScript JSP JUnit MySQL Networking Oracle Perl Perl PHP PL/SQL RSS Software QA SQL Server Struts Unix Windows XHTML XML

Home Hot About Collections Index RSS Atom Ask

Tester Developer DBA Windows JAR DLL Files Certificates RegEx Links Q&A Biotech Phones Travel FAQ Forum

Home > MySQL > Oracle > PL/SQL

✍: Guest

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, 5847👍, 0💬

Can one execute dynamic SQL from Forms?
Can one execute dynamic SQL from Forms? 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, 5848👍, 0💬

What is the difference between CALL_FORM, NEW_FORM and OPEN_FORM?
What is the difference between CALL_FORM, NEW_FORM and OPEN_FORM? CALL_FORM: start a new form and pass control to it. The parent form will be suspended until the called form is terminated. user can not navigate to parent form until child form is open. NEW_FORM: terminate the current form and replace... 2011-03-29, 5758👍, 0💬

What is CRUD testing and how does a tester test this?
What is CRUD testing and how does a tester test this? CRUD testing is actually Black Box testing. CRUD stands for (Create, Read, Update, Delete). I.e., whether you can Create or Add data, Whether you can Read or Access The Data after it is saved once, or whether you can Deteted the data along with i... 2011-03-31, 5479👍, 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, 5054👍, 0💬

Can one Maximize/ Minimize a Window in Forms?
Can one Maximize/ Minimize a Window in Forms? On MS-Windows, Forms run inside a Windows Multiple-Document Interface (MDI) window. You can use SET_WINDOW_PROPERTY on the window called FORMS_MDI_WINDOW to resize this MDI (or any other named) window. Examples: set_window_property(FORMS_MDI_ WINDOW,WIND... 2011-03-29, 4975👍, 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, 4637👍, 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, 4207👍, 0💬

What happened to SQL*Menu?
What happened to SQL*Menu? From Forms V4.5, SQL*Menu is fully integrated into Oracle Forms. Application menus can be added to your application by creating Menu Modules (*.MMB) and generate it to Menu Module Executables (*.MMX). 2011-04-26, 4160👍, 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, 3971👍, 0💬

.NET C C++ CSS DBA General HTML Java JavaScript JSP JUnit MySQL Networking Oracle Perl Perl PHP PL/SQL RSS Software QA SQL Server Struts Unix Windows XHTML XML

Home Hot About Collections Index RSS Atom Ask

Tester Developer DBA Windows JAR DLL Files Certificates RegEx Links Q&A Biotech Phones Travel FAQ Forum

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.