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 : What are OPEN_FORM,CALL_FORM,NEW_FORM? diff?
Last 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 ... was a called form, Oracle Forms runs the new form with the same options as the parent form.
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 : How can you execute the user defined triggers in forms 3.0 ?
Last Answer : Execute Trigger (trigger-name)
Description : What package procedure used for invoke sql *plus from sql *forms ?
Last Answer : Host (E.g. Host (sqlplus))
Description : What package procedure is used for calling another form ?
Last Answer : Call (E.g. Call(formname)
Description : To execute row from being displayed that still use column in the row which property can be used?
Last Answer : Format trigger.
Description : How can you execute a script file in SQLPLUS?
Last Answer : To execute a script file in SQLPlus, type @ and then the file name.
Description : An ECS transaction gets bounced and you are unable to recover your money from your customer. Under which Act criminal action can be initiated? A. Negotiable Instrument Act 1881 B. Criminal Procedure Code C. Payment and Settlement Systems Act 2007 D. Indian Companies Act 1956
Last Answer : C. Payment and Settlement Systems Act 2007 Explanation: Under the Section 25 of Payment and Settlement Systems (PSS) Act, 2007, dishonour of an electronic fund transfer instruction due to insufficiency ... fine or both, similar to the dishonour of a cheque under the Negotiable Instruments Act 1881.
Description : When the form is running in DEBUG mode, If you want to examine the values of global variables and other form variables, What package procedure command you would use in your trigger text ?
Last Answer : Break. SYSTEM VARIABLES
Description : What are the two parts of a procedure ?
Last Answer : Procedure Specification and Procedure Body.
Description : What ERASE package procedure does ?
Last Answer : Erase removes an indicated global variable.
Description : Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
Last Answer : A function and procedure are the same in that they are intended to be a collection of PL/SQL code that carries a single task. While a procedure does not have to return any ... functions and procedures that are grouped together based on their commonality to a business function or application.
Description : What are Procedure,functions and Packages
Last Answer : Procedures and functions consist of set of PL/SQL statements that are grouped together as a unit to solve a specific problem or perform set of related tasks. Procedures do not ... Provide a method of encapsulating and storing related procedures, functions, variables and other Package Contents
Description : Use the ADD_GROUP_ROW procedure to add a row to a static record group? I) TRUE II)FALSE
Last Answer : I) FALSE
Description : What is syntax for dropping a procedure and a function .Are these operations possible?
Last Answer : Drop Procedure procedure_name Drop Function function_name
Description : Difference between procedure and function.?
Last Answer : Functions are named PL/SQL blocks that return a value and can be called with arguments procedure a named block that can be called with parameter. A procedure all is a PL/SQL statement by itself, while a Function call is called as part of an expression.
Description : What is a Procedure ?
Last Answer : A Procedure consist of a set of SQL and PL/SQL statements that are grouped together as a unit to solve a specific problem or perform a set of related tasks.
Description : What is difference between a Cursor declared in a procedure and Cursor declared in a package specification ?
Last Answer : A cursor declared in a package specification is global and can be accessed by other procedures or procedures in a package. A cursor declared in a procedure is local to the procedure that can not be accessed by other procedures.
Description : What is difference between a PROCEDURE & FUNCTION ?
Last Answer : A FUNCTION is always returns a value using the return statement. A PROCEDURE may return one or more values through parameters or may not return at all.
Description : What is a stored procedure ?
Last Answer : A stored procedure is a sequence of statements that perform specific function.
Description : What are the modes of parameters that can be passed to a procedure ?
Last Answer : IN,OUT,IN-OUT parameters.
Description : Give the structure of the procedure ?
Last Answer : PROCEDURE name (parameter list.....) is local variable declarations BEGIN Executable statements. Exception. exception handlers end;
Description : Name the tables where characteristics of Package, procedure and functions are stored ?
Last Answer : User_objects, User_Source and User_error.
Description : What are the different types of Package Procedure ?
Last Answer : 1. Restricted package procedure. 2. Unrestricted package procedure.
Description : What is a Package Procedure ?
Last Answer : A Package procedure is built in PL/SQL procedure.
Description : Classify the restricted and unrestricted procedure from the following.
Last Answer : a. Call b. User-Exit c. Call-Query d. Up e. Execute-Query f. Message g. Exit-From h. Post i. Break? a. Call - unrestricted b. User Exit - Unrestricted c. Call_query - Unrestricted ... Query - Restricted f. Message - Restricted g. Exit_form - Restricted h. Post - Restricted i. Break - Unrestricted.
Description : What Enter package procedure does ?
Last Answer : Enter Validate-data in the current validation unit.
Description : Can we use a restricted package procedure in ON-VALIDATE-FIELD Trigger ?
Last Answer : No
Description : What the PAUSE package procedure does ?
Last Answer : Pause suspends processing until the operator presses a function key
Description : What is the difference between restricted and unrestricted package procedure ?
Last Answer : Restricted package procedure that affects the basic functions of SQL * Forms. It cannot used in all triggers except key triggers. Unrestricted package procedure that does not interfere with the basic functions of SQL * Forms it can be used in any triggers.
Description : EXIT_FORM is a restricted package procedure ?a. True b. False
Last Answer : True
Description : Where is a procedure return in an external pl/sql library executed at the client or at the server?
Last Answer : At the client.
Description : Use the Add_group_row procedure to add a row to a static record group 1. true or false?
Description : In solution, glucose exists as _________ (a) the open-chain form only (b) the cyclic hemiacetal form only (c) the cyclic acetal form only (d) an equilibrium mixture of the open-chain form and cyclic hemiacetal forms
Last Answer : an equilibrium mixture of the open-chain form and cyclic hemiacetal forms
Description : What are the two ways to incorporate images into a oracle forms application?
Last Answer : Boilerplate Images Image_items
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 : 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?
Description : Can u have VBX and OCX controls in forms ?
Last Answer : Yes.
Description : Can u have OLE objects in forms?
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 : What are the built_in used to trapping errors in forms 4?
Last Answer : Error_type return character Error_code return number Error_text return char Dbms_error_code return no. Dbms_error_text return char
Description : List the editors availables in forms 4.0?
Last Answer : Default editor User_defined editors system editors.