Debarghya

• Aug 29th, 2017

C. Character

Code
 

sunil

• Jul 20th, 2015

"Boolean" value is recorded

Answer Question  Select Best Answer

Mohammad

• Aug 16th, 2017

No, a canvas can have only one window at a time

VAZEER

• Aug 5th, 2011

No

Answer Question  Select Best Answer

deepak

• Jul 15th, 2017

I just use this code
but it is showing error - no list element defined for list item

deepak

• Jul 15th, 2017

Will you provide me the code for populating list
as I am sending to you my parameter
record group= country_name
item=:country.c_name
there is block name= table name and item name = column name

Answer Question  Select Best Answer

Lily

• Jul 6th, 2017

False

SWETA RANI

• Aug 3rd, 2016

False .
SYSTEM.EFFECTIVE_DATE Represents the effective database date. The variable value must always be in the following format DD-MON-YYYY HH24:MI:SS

Answer Question  Select Best Answer

How to apply form handlers in Oracle forms which we have already created in an application?

 Form   Menu   Library

sunil

• Jul 20th, 2015

Types of modules are:
Menu module
PL/SQL Libraries
Object Library

nishajan09

 Profile Answers by nishajan09 Questions by nishajan09

• Aug 11th, 2008

Form moduleMenu modulePl/SQL Library module Object Library module

Answer Question  Select Best Answer

What are static and dynamic reports in oracle and where do we use them?

kamaraj

• Jul 13th, 2015

Static reports query is known in design time
Dynamic reports query is known during run time only

Answer Question  Select Best Answer

Azhar Hussain

• Apr 28th, 2015

Yes it is possible indirectly,
On Pre-INSERT OR PRE-UPDATE assign to related database column

paddu_24

 Profile Answers by paddu_24 Questions by paddu_24

• Oct 27th, 2008

No its not possible

Answer Question  Select Best Answer

K.MOHANRAJ

• Jan 24th, 2015

YES, USING WEBUTIL

Answer Question  Select Best Answer

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

Ashish

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

asifinet

 Profile Answers by asifinet Questions by asifinet

• Feb 16th, 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...

Answer Question  Select Best Answer

VIKASH KUMAR

• Mar 12th, 2013

Use I/O package .

Answer Question  Select Best Answer

asifinet

 Profile Answers by asifinet Questions by asifinet

• Feb 16th, 2013

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

Answer Question  Select Best Answer

asifinet

 Profile Answers by asifinet Questions by asifinet

• Feb 16th, 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 ...

Answer Question  Select Best Answer

asifinet

 Profile Answers by asifinet Questions by asifinet

• Feb 16th, 2013

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

Answer Question  Select Best Answer

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

 Profile Answers by asifinet Questions by 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
 

Answer Question  Select Best Answer

 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

 Profile Answers by younaskhan40 Questions by 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.

Answer Question  Select Best Answer

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

 Profile Answers by rampratap409 Questions by rampratap409

• Dec 4th, 2006

yescreate procedure truncatetable(tname in varchar2) issqlstr varchar2(100);beginsqlstr := 'truncate table '||tname;execute immediate  sqlstr;end;

Answer Question  Select Best Answer

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 ?

Shital Mistry

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

Answer Question  Select Best Answer

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

Shital Mistry

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

Shital Mistry

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

Answer Question  Select Best Answer

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

keerthikannan v

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

Answer Question  Select Best Answer