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? ...
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) ...
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...
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...
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. ...
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. ...
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...
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)...
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. ...
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). ..... ---------------------...
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 ...
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....
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 ...
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...
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...
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...
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"> ...
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 ...
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...
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 ...