GeekInterview.com
Series: Subject: Topic:

Oracle Forms Interview Questions

Showing Questions 1 - 20 of 165 Questions
First | Prev | | Next | Last Page
Sort by: 
 | 

How to get number in words in Oracle 10g reports

Asked By: krishvim99 | Asked On: Jun 5th, 2011

How to get number in words we are using Oracle 10g software and in reports, I am trying to give as function code and return value as placeholder, but I am getting an error as foll.Rep:1401 'cf_1formula': fatal PL/SQL error occurred.Thanks in advancekrishnan r

Answered by: Ashish on: Mar 10th, 2014

"vb Function No_To_Word(Amount Number) Return Varchar2 Is Wordsamt Number(30, 12) := 0; Words Varchar2(500) := ; Str Varchar2(50) := ; Amt Number(30, 1...

Answered by: asifinet on: Feb 15th, 2013

"sql Set Serveroutput On 1000000 Declare V_Input NUMBER := &TESTED; Function Numbertowords(P_Number In Out Number) Return Varchar2 Is V_Words Varchar2(32767) := ; V_Te...

How to convert report 3.0 into excel

Asked By: muqthadeer | Asked On: Jun 8th, 2011

Answered by: VIKASH KUMAR on: Mar 12th, 2013

use I/O package .

How will you post two independent transactions in forms 6i

Asked By: rafioracledeveloper | Asked On: Jun 3rd, 2008

Answered by: asifinet on: Feb 15th, 2013

Declare the PRAGMA AUTONOMUS_TRANSACTION; in Procedure,Package,Function/Anonymous Block etc.

What are dynamic reports? How will you create them

Asked By: rafioracledeveloper | Asked On: Jun 3rd, 2008

Answered by: asifinet on: Feb 15th, 2013

Dynamic Reports are the Reports which is based on the GLOBAL_TEMPORARY TABLE. can be used in BEFORE RUN REPORT Trigger to populate the Data into that table by calling function/procedure. After report ...

Can we use program unit in a display field to create a formula calculated item?

Asked By: rafioracledeveloper | Asked On: Jun 3rd, 2008

Answered by: asifinet on: Feb 15th, 2013

Yes we can, in WHEN-NEW-RECORD-INSTANCE Trigger.

Background_color

Asked By: sanjeevkumar2010 | Asked On: Oct 20th, 2010

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.............

Answered by: asifinet on: Feb 15th, 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...

Answered by: SANJIT on: Jan 20th, 2013

Code
  1. SET_ITEM_PROPERTY(ACCOUNT_MASTER.ACCT_NO,CURRENT_ROW_BACKGROUND_COLOR,r100g50b0);
  2.  
  3. SET_ITEM_PROPERTY(ACCOUNT_MASTER.ACCT_NO,CURRENT_ROW_FOREGROUND_COLOR,r100g100b88);

The value recorded in system.Last_record variable is of type     a. Number     b. Boolean     c. Character.B. Boolean. user exits :

Asked By: Interview Candidate | Asked On: Sep 9th, 2004

Answered by: Shital Mistry on: Aug 11th, 2012

It is c. Character data type.

Answered by: Raj on: Oct 10th, 2011

It is of type Character as you always compare

if :system.last_record = 'TRUE' then
........
........
end if;

How do you pass the parameters from one form to another form?

Asked By: Interview Candidate | Asked On: Sep 9th, 2004

 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 ...

Answered by: Shital Mistry on: Aug 11th, 2012

Calling form must first create parameters under the parameter node.

Answered by: younaskhan40 on: 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.

Can you truncate a table in a procedure in Oracle forms? The table name is passed into the procedure.

Asked By: Amritha | Asked On: Jun 22nd, 2006

Answered by: Shital Mistry on: Aug 11th, 2012

It is not directly supported in forms, but FORMS_DDL built in can be used to TRUNCATE the table.

Answered by: rampratap409 on: Dec 4th, 2006

yes

create procedure truncatetable(tname in varchar2) is

sqlstr varchar2(100);

begin

sqlstr := 'truncate table '||tname;

execute immediate  sqlstr;

end;

Lists in Oracle forms

Asked By: kperumal75 | Asked On: Jul 6th, 2011

I want to make two lists in an Oracle form. Each list will be holding three elements. These elements are same for two lists. If one element is selected in one list that will not come in the other list. That means the other list will show only two elements. How can I do that dynamically ?

Answered by: Shital Mistry on: Aug 11th, 2012

use record group to hold the values of list items selected in first list populate second list dynamically only the items that you need and not contained in record group.

Message error

Asked By: nghiavt2004 | Asked On: Dec 17th, 2011

How can I get off a error message Oracle form a0001 ask me to save the record when I change a record to other ?

Answered by: Shital Mistry on: Aug 11th, 2012

If it an oracle error you are trying to trap than I would use ON-ERROR trigger on specific block, use built ins DBMS_ERROR_CODE, DBMS_ERROR_TEXT to trap the error.

Answered by: Shital Mistry on: Aug 6th, 2012

I would write ON_MESSAGE trigger on block level, trap particular message with built ins MESSAGE_CODE, MESSAGE_TEXT and handle the error...

Webutils

Asked By: sanjeevkumar2010 | Asked On: Oct 20th, 2010

Actual I am uploading the excel sheet data in the customer system that must generate into server system and store that excel sheet data into the particular database table...Plz help me.....We r trying from so many days ... My task has been stop there

Answered by: keerthikannan v on: Jan 23rd, 2012

Following Step need to setup before executing the Conversion Script Step 1: Logon to the Database server and connect to the database. Step 2: Run the below query and it should return five records: ...

What is folder form?

Asked By: bhaskar | Asked On: Sep 19th, 2007

Definitions, usage and its information in Oracle forms 9i

Answered by: Lokesh M on: Dec 8th, 2011

Oracle Applications - Folder Functionality are made use of in custom forms. Folder Functionality enables user to perform host of actions on fields such as ordering, renaming, resizing, moving, including, excluding etc., in a multi-row block.

How to populate list dynamically?

Asked By: anupam srivastava | Asked On: Dec 30th, 2005

Answered by: Sudipta Santra on: Oct 13th, 2011

First: check through Get_List_Element built_ins method that the both list has been selected with the value or not? if none is selected then all values should be populated . Second: Declare a varray a...

Answered by: kperumal75 on: Jul 6th, 2011

Create this procedure first:PROCEDURE Pop_List IS /* ** Built-in: CREATE_GROUP_FROM_QUERY **Example: Create a record group from a query, and populate it. */ list_id ITEM; list_name VARCHAR2(40) := &...

What is a trigger ?

Asked By: Interview Candidate | Asked On: Sep 9th, 2004

 a piece of logic that is executed at or triggered by a SQL *forms event. 

Answered by: Bashartullakhan on: Aug 17th, 2011

Triggers are a special PL/SQL construct similar to procedures. However, a procedure is executed explicitly from another block via a procedure call, while a trigger is executed implicitly whenever the triggering event happens. The triggering event is either a INSERT, DELETE, or UPDATE command.

Answered by: manishagoyal23 on: Sep 3rd, 2009

A forms trigger is a block of PL/SQL code that adds functionality to your application. Triggers are attached to objects in your application. When a trigger is fired, it executes the code it contai...

Can a single canvas have multiple windows ?

Asked By: Shweta | Asked On: Oct 13th, 2005

Answered by: VAZEER on: Aug 5th, 2011

no

Answered by: samareshp on: Apr 20th, 2009

a single canvas have multiple windows :: NO

a single windows have multiple canvas :: yes

Valid settings for the initial value property

Asked By: amazingrajiv | Asked On: May 31st, 2011

In an order entry form, the order_items block has a text item called shipping_date, which is of the date data type the lowest allowed value and the highest allowed value properties are not defined for this item.Assuming that all of the following are defined, which three are valid settings for the initial...

Answered by: dornalpr on: Jun 2nd, 2011

Valid values are: A, B & DIn forms, to give initial value as sysdate, we should user $$DBDATE$$ which gives the current time of server, which stores date of DD-MON-YYYY format. If you want to stor...

What erase package procedure does ?

Asked By: Interview Candidate | Asked On: Sep 9th, 2004

 erase removes an indicated GLobal variable.

Answered by: anitha palla on: Aug 13th, 2010

Erase removes an indicated global variable and releases the memory associated with it.

What is the difference between property pallete and visual attributes ?Also explain what is object group in Oracle forms ?

Asked By: sathish_p | Asked On: Jul 13th, 2007

Answered by: santhisistla on: Jul 29th, 2010

Property pallete is used to apply changes to only that object item, as visual attributes are used in more generic manner. Visual attributes are used  in the projects in which common specific...

Answered by: kyuvarajbe on: Jun 11th, 2010

Visual Attribute is the property in Property Pallete of object which deals with only text font,colour.

A query fetched 10 records how many times does a pre-query trigger  and post-query trigger will get executed ?

Asked By: Interview Candidate | Asked On: Sep 9th, 2004

 pre-query fires once.   post-query fires 10 times.

Answered by: younaskhan40 on: Apr 20th, 2010

PRE-QUERY fire once when block goes in execute-query Mode.
and
POST-QUERY  fire=TOTAL NUMBER OF RECORDS RETRIEVED.
in the above case POST-QUERY fires 10 times.

Answered by: AShutosh Trivedi on: Jun 10th, 2006

Pre_Query fires once

And Post_Query fires for each record means in this condition it fires 10 times.

    

First | Prev | | Next | Last Page

 

 

Ads

Connect

twitter fb Linkedin GPlus RSS

Ads

Interview Question

 Ask Interview Question?

 

Latest Questions

Interview & Career Tips

Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.