oracleforms

Source code control for Oralce Forms/Reports Builder

Am looking and testing all the source control solutions to use with Oracle Forms/Reports builders. but, none of the existing solutions works well with Oracle products. Any one out there did a similar practice? and how do you control the source codes of Oracle Forms/Reports? ...

Oracle Forms: Why can't I add a new Type Spec?

I wish to add a Type Spec to an Oracle Form. Unfortunately, this option is disabled in the "New Program Unit" dialog: Does anyone know how to add a Type Spec to an Oracle Form? Version of Oracle Forms Builder: Forms [32 Bit] Version 10.1.2.0.2 (Production) ...

Converting Oracle Forms to Apex - Is it worth considering the Apex Forms migration tool?

Friends, I am looking at migrating a Oracle Forms (10g) application to APEX (3.2.1) and looking at options that would enable me to get to a stage where I can obtain a "first cut" of the Oracle Form within APEX. Having got to grips with the Forms migration tool by reading this guide as well as this appendix and converted a couple of...

drag drop mysql web form builder

Hi, I would like to have a tool with which I can easily develop(dragNdrop) front-end for mysql table and publish it to web. I am not sure whether I can try oracle forms, as my database is MySQL. Even if I can use Oracle forms to connect to MySQL, I would like to know any other third party tool which can do the job easily & quickly. Th...

Scalability of Oracle Forms

What is your experience regarding the scalability of Oracle Forms? What's the maximum number of application users you would use Oracle Forms for: 100, 1000, 10000, 50000? I know that this question lacks many detail information for a well-founded answer. However, I am interested in the gut feeling of seasoned Forms developers. Thanks. ...

Evaluation of PL/SQL boolean variables in Oracle Forms

Suppose I have a BOOLEAN variable within a PL/SQL block in an Oracle Form: DECLARE is_viewable BOOLEAN; BEGIN is_viewable := ...; IF NOT is_viewable THEN raise_my_error(); // pseudo-code END IF; END; After stepping through this code several times with a debugger, I have determined that raise_my_error() never gets called. ...

Oracle Forms 6i master-detail question from a painfully new newbie

Hello, I have a form that contains 3 blocks (block a, b, c). There is a master-detail relationship between b (detail) and c (master). Data-flow: you enter an ID in block a, which in turn populates block c and corresponding details in block b. Control goes immediately to block c. Objective: I need to be able to update details of bloc...

Oracle Forms Trigger Question

Scenario: I have 3 data-blocks: a, b, c. data-block a has 3 items: customer_number, customer_name, account_id Dataflow: In data-block a, the user enters a customer_number. This will automatically populate items customer_name and account_id (if the account_id already exists in the database) as well as the other two data-blocks (b and c)...

Migrating Oracle Forms to Java

Does anyone know an automated solution to migrate Oracle Forms to Java desktop forms (e.g. a code generator whose input are Oracle Forms definition files and output is Java code in AWT/Swing/SWT/whatever)? Preferrably open-source or free, but commercial ones are also a possibility. ...

Oracle Forms 6i crashes with 0xC0000005 at start after installing patch 19

In short. After patch 19 has been installed I can't run any form: compiled with patch 18 or 19, by myself or others. Immediately after starting I get Windows error: -------------------------------- ifrun60.exe .... -------------------------------- The application failed to initialize properly (0xC0000005). ..... ---------------------...

how to begin learning oracle forms and reports ?

i have complete sql and plsql course and , i want to begin learn oracle forms and reports so i want to know how to begin and what i need (books , websites ..) thanks ...

Oracle forms 10g, running a form

Hi guys, I have been facing trouble with running oracle 10g forms, I tried everything I know but it did not work. So please help me. My computer specifications: OS: windows xp service pack 2. Internet browser: Mozilla Firefox 3.6 RC 2. Database: Oracle 10g 10.2.0. Oracle developer suite 10g. JInitiator 1.3.1.30. jre-6u18-windows-i586....

Run Oracle Forms as standalone without browser

I want to run Oracle Forms standalone without any web-browser with java plugin. Is there a way to call a compiled .fmx form directly via some java application or by calling the forms-JAR-files with some parameters? CU, Arne ...

Oracle forms API - c-based compile error

i am trying to compile a c-based forms api program on Linux x86_64 using command gcc -m32 -I"$ORACLE_HOME/forms/api" -L"$ORACLE_HOME/forms/lib" -L"$ORACLE_HOME/lib" -ld2f fapi.c it fails with a bunch of undefined references. $ORACLE_HOME/lib/libd2f.so: undefined reference to `sifom' $ORACLE_HOME/lib/libd2f.so: undefined ref...

How do I gain Control of a row in Tabular Layout in Oracle

This might be simple but I am new to Oracle. I am using Oracle 10g and have a form that lists our information from a linked table in a tabular Layout. The last column of data is a "list Item" item type that has the Element list of Enabled (T) and Disabled (F). What I need is when a user changes this dropdown, to disabled, I want ONLY th...

ORACLE FORMS builder

Hi guys , i'm having a problem when trying to MAXIMIZE ORACLE forms builder's window ; i've tried all the right commands ( set_windw_property ) also i've edited the formsweb.cfg file (width , hieght and separate) . Can anyone help me with such an issuse ?? Kindly note that i'm using - Forms [32 Bit] Version 10.1.2.0.2 (Production); on w...

Question about <foreach> task and the failonerror attribute‏

Hi guys, I have made a build file for the automated compilation of Oracle Forms files. An excerpt of the code is as follows: <target name="build" description="compiles the source code"> ... <foreach item="File" property="filename" failonerror="false" > <in> <items basedir="${source.directory}\${project.type}\Forms"> ...

oracle adf or oracle forms

Hi all, What are the advantages of oracle forms over adf, and also disadvantages. Does some companies replaces oracle forms with adf and why? Regards ...

One blank line in list item

Hi there. I try to write a code to fill my list item in oracle form builder. I do it by write a function to handle this. list_index number(10) := 1; clear_list(list_item1); FOR I IN (Select id,desc FORM table1) LOOP ADD_LIST_ELEMENT('list_item1',list_index,desc,id); list_index := list_index + 1; END LOOP list_item1 := get_list_el...

How do Oracle Forms compare to Microsoft Access as a "front-end"?

I recently started a project where I was set to build an ADP based application in Access 2003. The font end GUI was going to be in Access while all the data resided in MS SQL Server. I say "was", because the powers that be have decided that Oracle Forms might be a better choice than Access and SQL Server. The place where I am doing this ...