What are the built_in used to trapping errors in forms 4?

1 Answer

Answer :

Error_type return character
Error_code return number
Error_text return char
Dbms_error_code return no.
Dbms_error_text return char

Related questions

Description : What are the common RMAN errors (with solutions)? (for DBA

Last Answer : Some of the common RMAN errors are: RMAN-20242: Specification does not match any archivelog in the recovery catalog. Add to RMAN script: sql 'alter system archive log current'; RMAN-06089: archived log xyz not found or out of sync with catalog Execute from RMAN: change archivelog all validate;

Description : You have just compiled a PL/SQL package but got errors, how would you view the errors?

Last Answer : SHOW ERRORS

Description : Where would you look for errors from the database engine?

Last Answer : In the alert log.

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

Last Answer : Boilerplate Images Image_items

Description : How can you execute the user defined triggers in forms 3.0 ?

Last Answer : Execute Trigger (trigger-name)

Description : How do you call other Oracle Products from Oracle Forms?

Last Answer : Run_product is a built-in, Used to invoke one of the supported oracle tools products and specifies the name of the document or module to be run. If the called product is unavailable at the time of the call, Oracle Forms returns a message to the operator.

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

Last Answer : Yes

Description : For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame?

Last Answer : Yes

Description : Can u have VBX and OCX controls in forms ?

Last Answer : Yes.

Description : Can u have OLE objects in forms?

Last Answer : Yes.

Description : Can u set default font in forms?

Last Answer : Yes. Change windows registry(regedit). Set form45_font to the desired font.

Description : Can you issue DDL in forms?

Last Answer : yes, but you have to use FORMS_DDL. Referencing allows you to create objects that inherit their functionality and appearance from other objects. Referencing an object is similar to copying an ... values of bind variables can be concatenated into the string before passing the result to FORMS_DDL.

Description : Is forms 4.5 object oriented tool ? why?

Last Answer : yes , partially. 1) PROPERTY CLASS - inheritance property 2) OVERLOADING : procedures and functions.

Description : How image_items can be populate to field in forms 4.0?

Last Answer : A fetch from a long raw database column PL/Sql assignment to executing the read_image_file built_in procedure to get an image from the file system.

Description : What is a library in Forms 4.0?

Last Answer : A library is a collection of Pl/SQL program units, including user named procedures, functions & packages

Description : What are the built-in routines is available in forms 4.0 to create and manipulate a parameter list?

Last Answer : Add_parameter Create_Parameter_list Delete_parameter Destroy_parameter_list Get_parameter_attr Get_parameter_list set_parameter_attr

Description : What are the design facilities available in forms 4.0?

Last Answer : Default Block facility. Layout Editor. Menu Editor. Object Lists. Property Sheets. PL/SQL Editor. Tables Columns Browser. Built-ins Browser.

Description : List the editors availables in forms 4.0?

Last Answer : Default editor User_defined editors system editors.

Description : Give the equivalent term in forms 4.0 for the following. Page, Page 0?

Last Answer : Page - Canvas-View Page 0 - Canvas-view null.

Description : What are the menu items that oracle forms 4.0 supports?

Last Answer : Plain, Check,Radio, Separator, Magic

Description : What is a predefined exception available in forms 4.0?

Last Answer : Raise form_trigger_failure

Description : List system variables available in forms 4.0, and not available in forms 3.0?

Last Answer : System.cordination_operation System Date_threshold System.effective_Date System.event_window System.suppress_working

Description : List the windows event triggers available in Forms 4.0?

Last Answer : When-window-activated, when-window-closed, when-window-deactivated, when-window-resized

Description : What is the significance of PAGE 0 in forms 3.0 ?

Last Answer : Hide the fields for internal calculation.

Description : What package procedure used for invoke sql *plus from sql *forms ?

Last Answer : Host (E.g. Host (sqlplus))

Description : How do you control the constraints in forms ?

Last Answer : Select the use constraint property is ON Block definition screen.BLOCK

Description : What is an SQL *FORMS ?

Last Answer : SQL *forms is 4GL tool for developing and executing; Oracle based interactive application.

Description : How do you trap the error in forms 3.0 ?

Last Answer : using On-Message or On-Error triggers.

Description : What are the default extensions of the files created by forms modules?

Last Answer : .fmb - form module binary .fmx - form module executable

Description : What is the difference between object embedding & linking in Oracle forms?

Last Answer : In Oracle forms, Embedded objects become part of the form module, and linked objects are references from a form module to a linked source file.

Description : Can you pass data parameters to forms?

Last Answer : No

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 are the Built-ins used for sending Parameters to forms?

Last Answer : You can pass parameter values to a form when an application executes the call_form, New_form, Open_form or Run_product.

Description : How to really break-out from the "don't have related Degree, can't have job" trapping dilemma?

Last Answer : answer:I would try to get a low-level job or even internship (apprenticeship) in the field you are trying to break into and possibly if you show your worth, the employer would, at some point, pay ... is hard to be more specific without knowing what field you are coming from or trying to get into.

Description : How if you exert more energy in creating periodic waves trapping the surface with greater strength?

Last Answer : Need answer

Description : Why people stopped hunting and trapping all the Tasmanian devils?

Last Answer : Need answer

Description : What wife of Henry the eighth was the first accused of trapping the king with a philter And then beheaded for unfaithfulness?

Last Answer : Need answer

Description : What wife of Henry the eighth was accused of trapping the king with a philter and then beheaded for unfaithfulness?

Last Answer : Need answer

Description : The following statement(s) is/are true concerning host defense mechanisms to intraabdominal infection. a. Bacterial clearance can occur via translymphatic absorption b. Phagocytic activity and bacterial killing can ... may be walled off but are seldom sealed by the omentum and other mobile viscera

Last Answer : Answer: a, b, c The introduction of microorganisms into the normally sterile peritoneal environment invoke several potent specialized host antimicrobial defense mechanisms. Bacterial clearance, ... the contaminated enteric contents walled off, preventing continued soilage of the peritoneal cavity

Description : Algae often float on surface of water during the day but sink down during the night due to (a) Evolution and trapping of oxygen bubbles during the day in their photosynthesis (b) Becoming light as they ... (c) Warming action of sun during the day (d) Release of absorbed air by warming of water

Last Answer : Ans:(a)

Description : 'Green House Effect' means – (1) Pollution in houses in tropical regions (2) Trapping of solar energy due to atmospheric oxygen (3) Trapping of solar energy due to atmospheric carbon dioxide (4) Cultivation in green houses so as to check pollution

Last Answer : (3) Trapping of solar energy due to atmospheric carbon dioxide Explanation: The greenhouse effect is a process by which thermal radiation from a planetary surface is absorbed by atmospheric ... fuels and clearing of forests, have intensified the natural greenhouse effect, causing global warming.

Description : 'Green House Effect' means - (1) cultivation of crops in green house to conserve heat (2) trapping of solar energy due to carbon dioxide gases (3) trapping of solar energy by earth upper surface (4) increase of heat due to atmospheric pollution

Last Answer : (2) trapping of solar energy due to carbon dioxide gases Explanation: Green House Effect is a process by which thermal radiation from a planetary surface is absorbed by atmospheric greenhouse gases and is re-radiated in all directions.

Description : Green House Effect' means (1) Pollution in houses in tropical region (2) Prevention of ultraviolet radiation by the ozone layer (3) Trapping of solar energy due to atmospheric gases (4) Damage to green painted buildings

Last Answer : (3) Trapping of solar energy due to atmospheric gases Explanation: The greenhouse effect occurs when Earth's atmosphere traps solar radiation because of the presence of certain gases, causing the ... , nitrous oxide (N2O) and other gases, ac-cording to the Environmental Protection Agency (EPA

Description : Which of the following green house gases has the greatest heat trapping ability? (1) Chlorofluoro carbon (2) Methane (3) Carbon dioxide (4) Nitrous oxide

Last Answer : (1) Chlorofluoro carbon Explanation: Gases that trap heat in the atmosphere are called green house gases. Global Warming Potentials (GWPs) are used to compare the abilities of different green house gases to trap ... 1.2. The higher the GWP, the more heat the specific gas can keep in the atmosphere.

Description : Back-trapping in a distillation column (A) Increases tray efficiency (B) Decreases tray efficiency (C) Reduces pressure drop (D) Is desirable, as it provides improved vapour-liquid contact

Last Answer : (B) Decreases tray efficiency

Description : Inland Fisheries is referred to? a. Extraction of oil from fish b. Deep sea fisheries c. Trapping and capturing fish d. Culturing fish in freshwater e. None of the above

Last Answer : d. Culturing fish in freshwater

Description : Dams are designed to reduce flooding by ____________. a) Protecting river banks from erosion b) Providing storage for flood water c) Increasing the downstream velocity of flood water ‘ d) Trapping sediment behind the dam so it can't be deposited downstream

Last Answer : b) Providing storage for flood water

Description : Dams are designed to reduce flooding by _______________. a) Protecting river banks from erosion b) Providing storage for flood water c) Increasing the downstream velocity of flood water d) Trapping sediment behind the dam so it can't be deposited downstream

Last Answer : b) Providing storage for flood water

Description : The Golgi complex plays a major role (a) as energy transferring organelles (b) in post translational modification of proteins and glycosylation of lipids (c) in trapping the light and transforming it into chemical energy (d) in digesting proteins and carbohydrates.

Last Answer : (b) in post translational modification of proteins and glycosylation of lipids

Description : Which of the following structures protects the shore by trapping of littoral drift? (A) Groynes (B) Sea walls (C) Revetments (D) Moles

Last Answer : (A) Groynes