What are OPEN_FORM,CALL_FORM,NEW_FORM? diff?

1 Answer

Answer :

CALL_FORM : It calls the other form. but parent remains active, when
called form completes the operation , it releases lock and control goes
back to the calling form.
When you call a form, Oracle Forms issues a savepoint for the called
form. If the CLEAR_FORM function causes a rollback when the called
form is current, Oracle Forms rolls back uncommitted changes to this
savepoint.
OPEN_FORM : When you call a form, Oracle Forms issues a savepoint
for the called form. If the CLEAR_FORM function causes a rollback when
the called form is current, Oracle Forms rolls back uncommitted
changes to this savepoint.
NEW_FORM : Exits the current form and enters the indicated form. The
calling form is terminated as the parent form. If the calling form had
been called by a higher form, Oracle Forms keeps the higher call active
and treats it as a call to the new form. Oracle Forms releases memory
(such as database cursors) that the terminated form was using.
Oracle Forms runs the new form with the same Runform options as the
parent form. If the parent form was a called form, Oracle Forms runs
the new form with the same options as the parent form.

Related questions

Description : What is difference between open_form and call_form?

Last Answer : when one form invokes another form by executing open_form the first form remains displayed, and operators can navigate between the forms as desired. when one form invokes another form by executing ... are disabled, and operators cannot navigate to them until they first exit the called form.

Description : What is new_form built-in?

Last Answer : When one form invokes another form by executing new_form oracle form exits the first form and releases its memory before loading the new form calling new form completely replace the first with the second ... the first form, the operator will be prompted to save them before the new form is loaded.

Description : When a form is invoked with call_form, Does oracle forms issues a save point?

Last Answer : Yes

Description : Any attempt to navigate programmatically to disabled form in a call_form stack is allowed?

Last Answer : False

Description : An open form can not be execute the call_form procedure if you chain of called forms has been initiated by another open form?

Last Answer : True

Description : What is the main diff. bet. Reports 2.0 & Reports 2.5?

Last Answer : Report 2.5 is object oriented.

Description : Diff. between VAT and Property Class? imp

Last Answer : Named visual attributes define only font, color, and pattern attributes; property classes can contain these and any other properties. You can change the appearance of objects at runtime by ... visual attribute settings take precedence, and any visual attribute properties in the class are ignored.

Description : What is the diff. bet. setting up of parameters in reports 2.0 reports2.5?

Last Answer : LOVs can be attached to parameters in the reports 2.5 parameter form.

Description : What is the diff. when confine mode is on and when it is off?

Last Answer : When confine mode is on, an object cannot be moved outside its parent in the layout.

Description : What is the diff. when Flex mode is mode on and when it is off?

Last Answer : When flex mode is on, reports automatically resizes the parent when the child is resized.

Description : If a parameter is used in a query without being previously defined, what diff. exist betw. report 2.0 and 2.5 when the query is applied?

Last Answer : While both reports 2.0 and 2.5 create the parameter, report 2.5 gives a message that a bind parameter has been created.

Description : Cheapest option for moving my car to a diff. State...

Last Answer : You could drive it.

Description : Anyone here had C Diff?

Last Answer : C diff? That is quite a reach. If anyone here had it would make no difference for you. You need a diagnosis, not a comparison of symptoms. Antibiotics often make changes temporarily in the digestive system. ... is C diff, you don't want to sit around chatting about it, you want to get treated.

Description : What's the diff. between "I feel sick" and "I feel sickly"?

Last Answer : i think sickly implies a constant sort of icky, sick fatigue. sick is a physiological thing.

Description : Does anyone still care about the diff. between it's & its?

Last Answer : answer:Ha! Yes, people still care, and by people, I mean English teachers and proofreaders. The distinction between the two is observed in every print (and web) publication, and I think messing up ... actually useful!) but I like to think that it still makes you look dumb to confuse the two.

Description : Do you still have to remember usernames with "SuperGenPass"? what about password lenght requirements that are diff on diff sites, also: any alternatives you guys use that's 100% hacker safe?

Last Answer : answer:i just use the same…i don’t care that people see me on empornium etc. but ofcourse, everything will never be fully hackproof…

Description : Column 1,2 and 3 contain starting materials, reaction conditions, and type of reactions, respectively The only CORRECT combination that gives two diff

Last Answer : Column 1,2 and 3 contain starting materials, reaction conditions, and type of reactions, respectively The only CORRECT ... )(i)(S) D. (III)(iii)(P)

Description : how can i the diff between a female geese or male gander ?

Last Answer : There is no way to visually tell the difference between male and female Goose. This species is 76-110 cm (30-43 in) long with a 127-180 cm (50-71 in) wing span.[3] Males usually ... or a drawn out whinny - "wheee-oow". Anyone who has raised domestic geese will immediately recognize these calls.

Description : As shown in the illustrations, fine adjustments such as 'weather' and 'turning rate' have no effect on steering stand operation when the 'operation control switch' is in ____________. EL-0097 A. GYRO B. HAND C. NFU D. DIFF

Last Answer : Answer: C

Description : What is the diff. between electronic regulator and ordinary rheostat regulator for fans?

Last Answer : The difference between the electronic and ordinary regulator is that in electronic reg. power losses are less because as we decrease the speed the electronic reg. give the power needed for ... speed is controlled but in rheostatic control resistance is decreased by steps to achieve speed control.

Description : What is the diff. btwn. Electronic regulator and ordinary rheostat regulator for fans?

Last Answer : A: The difference between the electronic and ordinary regulator is the fact that in electronic reg. power losses tend to be less because as we minimize the speed the electronic reg. give ... speed is controlled but in rheostatic control resistance is decreased by steps to achieve speed control.

Description : Describe working of diff and cmp file handling commands with example.

Last Answer : Diff command: diff stands for difference. This command is used to display the differences in the files by comparing the files line by line. it tells us which lines in one file have is to be changed to make the two files ... $ cat file1 abcd xyz $ cat file2 Abed wxy $_  

Description : What does "jumps off the screen" mean?

Last Answer : answer:AMD is a relatively small manufacturer but well established in the industry. In this context, AMD jumps off the screen at the guy doing the research into acquiring companies for ... chip manufacturing division, but AMD is the one that really stands out from an acquisition perspective.

Description : How to add conditions in select statement in oracle?

Last Answer : Just add the decode

Description : How can I dump an oracle schema to a LOCAL file over a network connection from sqlplus?

Last Answer : By connecting and spooling are you excluding the exp/imp commands (or expdb/impdb in 10g)?

Description : What are the two ways to incorporate images into a oracle forms application?

Last Answer : Boilerplate Images Image_items

Description : Can one export a subset of a table? (for DBA

Last Answer : From Oracle8i one can use the QUERY= export parameter to selectively unload a subset of the data from a table. Look at this example: exp scott/tiger tables=emp query=\"where deptno=10\"

Description : What are the types of visual attribute settings?

Last Answer : Custom Visual attributes Default visual attributes Named Visual attributes. Window

Description : How does one use the import/export utilities? (for DBA

Last Answer : Look for the "imp" and "exp" executables in your $ORACLE_HOME/bin directory. One can run them interactively, using command line parameters, or using parameter files. Look at the imp/exp parameters ... and export data with the "Schema Manager" GUI that ships with Oracle Enterprise Manager (OEM).

Description : what is a display item?

Last Answer : Display items are similar to text items but store only fetched or assigned values. Operators cannot navigate to a display item or edit the value it contains.

Description : What is import/export and why does one need it? (for DBA

Last Answer : The Oracle export (EXP) and import (IMP) utilities are used to perform logical database backup and recovery. They are also used to move Oracle data from one machine, database or schema to ... corruption. Ensure that all the data can be read. . Transporting tablespaces between databases . Etc.

Description : Are there any troubleshooting tips for OEM? (for DBA

Last Answer : . Create the OEM repository with a user (which will manage the OEM) and store it in a tablespace that does not share any data with other database users. It is a bad practice to create ... successfully. Check the log to see the results of the execution rather than relying on this status.

Description : Where can one get more information about TCL? (for DBA

Last Answer : One can write custom event checking routines for OEM using the TCL (Tool Command Language) language. Check the following sites for more information about TCL: . The Tcl Developer Xchange - ... the OraTCL package . Tom Poindexter's Tcl Page - Oratcl was originally written by Tom Poindexter

Description : How does one start the Oracle Intelligent Agent? (for DBA

Last Answer : One needs to start an OIA (Oracle Intelligent Agent) process on all machines that will to be managed via OEM. For OEM 9i and above:

Description : What is the Oracle Intelligent Agent? (for DBA

Last Answer : The Oracle Intelligent Agent (OIA) is an autonomous process that needs to run on a remote node in the network to make the node OEM manageable. The Oracle Intelligent Agent is ... events registered in Enterprise Manager; and . Executing tasks associated with jobs submitted to Enterprise Manager.

Description : What are the types of SQL Statement ?

Last Answer : Data Definition Language : CREATE,ALTER,DROP,TRUNCATE,REVOKE,NO AUDIT & COMMIT.

Description : How does one backout events and jobs during maintenance slots? (for DBA

Last Answer : Managemnet and data collection activity can be suspended by imposing a blackout. Look at these examples: agentctl start blackout # Blackout the entrire agent agentctl stop blackout # Resume normal monitoring ... management agentctl start blackout -s jobs -d 00:20 # Blackout jobs for 20 minutes

Description : What are the pre requisites ?

Last Answer : I. to modify data type of a column ? ii. to add a column with NOT NULL constraint ? To Modify the datatype of a column the column must be empty. to add a column with NOT NULL constrain, the table must be empty.

Description : What kind of jobs can one schedule with OEM? (for DBA

Last Answer : OEM comes with pre-defined jobs like Export, Import, run OS commands, run sql scripts, SQL*Plus commands etc. It also gives you the flexibility of scheduling custom jobs written with the TCL language.

Description : Difference between SUBSTR and INSTR ?

Last Answer : INSTR (String1,String2(n,(m)),INSTR returns the position of the mth occurrence of the string 2 instring1. The search begins from nth position of string1.SUBSTR (String1 n,m)SUBSTR returns a character string of size m in string1, starting from nth position of string1.

Description : Should the OEM Console be displayed at all times (when there are scheduled jobs)? (for DBA

Last Answer : When a job is submitted the agent will confirm the status of the job. When the status shows up as scheduled, you can close down the OEM console. The processing of the job is managed by the OIA ... that OEM will not be able to send e-mail and paging notifications when the Console is not started.

Description : Explain UNION,MINUS,UNION ALL, INTERSECT ?

Last Answer : INTERSECT returns all distinct rows selected by both queries.MINUS - returns all distinct rows selected by the first query but not by the second.UNION - returns all distinct rows selected by either queryUNION ALL - returns all rows selected by either query, including all duplicates.

Description : WHY USE RMAN ? (for DBA

Last Answer : No extra costs Its available free ?RMAN introduced in Oracle 8 it has become simpler with newer versions and easier than user managed backups ?Proper security ?You are 100% sure your ... what need to backed up Knows what is required for recovery Knows what backups are redundant

Description : WHAT IS RMAN ? (for DBA

Last Answer : Recovery Manager is a tool that: manages the process of creating backups and also manages the process of restoring and recovering from them.

Description : What is the basic structure of PL/SQL ?

Last Answer : PL/SQL uses block structure as its basic structure. Anonymous blocks or nested blocks can be used in PL/SQL.

Description : What are the two parts of a procedure ?

Last Answer : Procedure Specification and Procedure Body.

Description : What are the datatypes a available in PL/SQL ?

Last Answer : Some scalar data types such as NUMBER, VARCHAR2, DATE, CHAR, LONG, BOOLEAN. Some composite data types such as RECORD & TABLE.

Description : What are the return values of functions SQLCODE and SQLERRM ? What is Pragma EXECPTION_INIT ? Explain the usage ?

Last Answer : SQLCODE returns the latest code of the error that has occurred. SQLERRM returns the relevant error message of the SQLCODE.

Description : What is Overloading of procedures ?

Last Answer : The Same procedure name is repeated with parameters of different datatypes and parameters in different positions, varying number of parameters is called overloading of procedures. e.g. DBMS_OUTPUT put_line

Description : s it possible to set a filter condition in a cross product group in matrix reports?

Last Answer : No