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

Can one change the mouse pointer in Forms?
Can one change the mouse pointer in Forms? The SET_APPLICATION_PROPERTY build-in in Oracle Forms allows one to change the mouse pointer. Example: SET_APPLICATION_PROPERTY(CURSO R_STYLE,BUSY); The following cursor styles are supported: * BUSY - Specifies a busy symbol * CROSSHAIR - Specifies a crossh... 2011-04-19, 7687👍, 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, 6949👍, 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, 6082👍, 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, 5783👍, 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, 5701👍, 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, 5637👍, 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, 4791👍, 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, 4778👍, 0💬

Why doesn't my messages show on the screen?
Why doesn't my messages show on the screen? Regardless of whether you call the MESSAGE() built-in with ACKNOWLEDGE, NO_ACKNOWLEDGE, or with no mode specification at all, your message may or may not be displayed. This is because messages are displayed asynchronously. To display messages immediately, ... 2011-04-19, 4541👍, 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.