-
Is it possible to attach same library to more than one form?
Yes
-
How do you pass the parameters from one form to another form?
To pass one or more parameters to a called form, the calling form must perform the following steps in a trigger or user named routine execute the create_parameter_list built-in function to programmatically. Create a parameter list to execute the add parameter built-in procedure...
Shital Mistry
- Aug 11th, 2012
Calling form must first create parameters under the parameter node.
younaskhan40
- Apr 16th, 2010
Create parameter list.Add required parameters with add_parameter(receiving_parameter_name, field type, sending_parameter_name)Now pass this into call_form or open_form built_in procedure.
-
What are the built-in routines is available in forms 4.0 to create and manipulate a parameter list?
Add_parameter Create_Parameter_list Delete_parameter Destroy_parameter_list Get_parameter_attr Get_parameter_list set_parameter_attr
imranbaig.geek
- Mar 25th, 2010
Parameter list built-ins in Forms 10g ADD_PARAMETER CREATE_PARAMETER_LIST DELETE_PARAMETERDESTROY_PARAMETER_LISTGET_PARAMETER_ATTRID_NULLRUN_PRODUCTSET_PARAMETER_ATTR RegardsImran Baig
g_sidhu
- Feb 15th, 2008
GET_PARAMETER_LISTDESTROY_PARAMETER_LISTCREATE_PARAMETER_LISTADD_PARAMETERDelete_parameterADD_LIST_ELEMENT(item, index, label, value) SET_PARAMETER_ATTR(List, key, paramtype, value) for a Date parameter defined at design timeGet_parameter_attr
-
Convert rdf data into excel format
How to convert rdf data into excel format directly report builder when the report is initialized then output of this report into excel?
imranbaig.geek
- Mar 25th, 2010
Text_IO Package in Oracle reports 10g Procedure/Exception/Function DescriptionTEXT_IO.FCLOSE procedure that closes an open file.TEXT_IO.FILE_TYPE type that specifies a h...
-
How to create exe file of oracle9i application?
g_sidhu
- Feb 13th, 2008
When you work in the Form Builder, you are creating binary files, and when you run an application, you are executing executable files. Forms stores its binary files with an .fmb extension and its exec...
bahubcd
- Jan 28th, 2008
There won,t be any .exe file methodology in Oracle 9i as far as i know. The OC4J instance should be turned on and the .fmx files should be present on the server and then you can access the forms by using the ip or the url set by you in forms run time configuration.
-
Can a Calculated item be stored in a database
Azhar Hussain
- Apr 28th, 2015
Yes it is possible indirectly,
On Pre-INSERT OR PRE-UPDATE assign to related database column -
Data which are checked in control block should be populated in detailed block
hello,i am facing one problem. I have one main form. In that when i press one button, one window will be pop up with the details of Orders for the particular supplier which was selected in main form. I will check only few orders which i need and when ever i click submit, those checked records should populate in the detailed grid. Popup window is based on control block.One record it is populating. But...
V12345
- Oct 14th, 2008
Try moving the pointer in the detailed block to NEXT_RECORD after you populate each record
samrat_misra
- Aug 14th, 2008
First go to the first record of that block from which you want to populate data, check whether that is checked or not, if checked then assigned those values into that block where you want to poulate. Loop untill the last record is fetched. May be it can resolve your problem
-
Background_color
In the Manual datablock , we will get records from database then I need to get each row in different color ......I am using the set_item_property('blockname.item',current_row_background_color,'red');plz help me.............
asifinet
- Feb 16th, 2013
You can use SET_BLOCK_PROPERTY(blk_name,record_no, CURRENT_RECORD_ATTRIBUTE,Visual_attribute_name); Must create two Visual Attributes one with yellow background color one with default name them VA_Y...
SANJIT
- Jan 20th, 2013
Code -
While specifying master/detail relationship between two blocks specifying the join condition is a must ? True or False. ?
True.
Thileepan
- Jun 12th, 2007
False. It is not a MUST.Using PL/SQL ref cursors we can maintain data retrieval conditions for master / detail blocks. Also we can handle join conditions at run time too.
-
What does an on-clear-block Trigger fire?
It fires just before SQL * forms the current block.
-
Explain types of Block in forms4.0?
Base table Blocks. Control Blocks. 1. A base table block is one that is associated with a specific database table or view. 2. A control block is a block...
g_sidhu
- Feb 13th, 2008
Base-table blocks, as their name implies, are based on a database table or view and must contain at least one item that is based on a column in that database table or view. If you create a block based...
manikandan
- Dec 24th, 2006
1)Datablocks that is directly related to base tables thru stored proc or views and 2,control blocks not associated with base tables
-
What are User Exits ?
sumanpani
- Sep 16th, 2008
A user exit is a program that you write and then link into the Report Builder executable or user exit DLL files. You build user exits when you want to pass control from Report Builder to a program you have written, which performs some function, and then returns control to Report Builder.
Devi Prasad Mishra
- Sep 30th, 2005
User Exits is a program which is used to pass the control from the Report Builder to a third generation language for performing complex calculations and returning the value back to the Report Builder.
-
How can you call a form on a form
muniyuga
- Oct 24th, 2009
The communication between forms can be done in the following 3 wayslet say Form A calls FormB1.Using New_Form: this Terminates Form A and activates Form BThe NewForm will terminates your current activ...
sumanpani
- Sep 16th, 2008
By using Gobal Variable we can call ?Form to Form?Form to Report?Form to Graph
-
Can you truncate a table in a procedure in Oracle Forms? The table name is passed into the procedure.
Shital Mistry
- Aug 12th, 2012
It is not directly supported in forms, but FORMS_DDL built in can be used to TRUNCATE the table.
rampratap409
- Dec 4th, 2006
yescreate procedure truncatetable(tname in varchar2) issqlstr varchar2(100);beginsqlstr := 'truncate table '||tname;execute immediate sqlstr;end;
-
What are the different types of key triggers ?
Function Key Key-function Key-others Key-startup
-
Give the Types of modules in a form?
Form Menu Library
sunil
- Jul 20th, 2015
Types of modules are:
Menu module
PL/SQL Libraries
Object Library -
What are the different types of windows?
Root window, secondary window.
g_sidhu
- Feb 13th, 2008
There are two styles of windows in Forms: document and dialog. Document windows are commonly used for data entry and query screens; they are the main windows in an application. Dialog windows are used...
-
What are the types of canvas-views?
Content View, Stacked View.
manish
- Sep 17th, 2006
Conetent View(Default)Stack View(Only create on content canvas only)Tab ViewToolbar View(Vertical/Horizontal)--Always try to connect it with window for many forms in one application.
-
-
Hi,what is place holder column?where we can use other than formula column?
sumanpani
- Sep 16th, 2008
A placeholder is a column for which you set the datatype and value in PL/SQL that you define. You can set the value of a placeholder column in the following places: n the Before Report Trig...
rampratap409
- Dec 6th, 2006
Place holder column is the name of variable which can hold a calculated value like ( sum, avg..) or the value can be set by function or by a pl/sql block.use of place holder column for aggrigate function is not advised, for that use summary column.
Oracle Forms Interview Questions
Ans