I am trying to make a simple interface for a small table. I am trying to make the it auto generated. The creation of the table as the following: create table Buyer_Entery_Table ( serial_number number(6) not null customers_seq, good_name varchar2(300), employee_name varchar2(400), Quantity number(6), value number(10), entry_number number(6), outer_number number(6), today date, department_name varchar2(300), notes varchar2(400) ); I created a sequence as well as the following: CREATE SEQUENCE customers_seq START WITH 1 INCREMENT BY 1 NOCACHE NOCYCLE; In the form builder, I add a trigger in the block level. The trigger is PRE-INSERT. I used This code: declare v_no number; Begin select customers_seq.nextval into v_no from Dual;:Buyer_Entery_table.serial_number:= v_no; end; I have tried to compile.

Developer 6i Patch 14 After Success Instalation Of Deleloper 6i on Pentium-IV, While runing the Wizard Oracle Net8 Easy Config to connect the Oracle Server (Database) it is showing error: Jrew This Program has Perfrom illegal Oparation. I want to download the patch 17 for oracle developer 6i for can anyone know a link that i can download this patch from it? Report message to a moderator. Messages: 14 Registered: November 2005 Location: jeddah Junior Member. I want to download patch 17.

I have the following error. ORA-00600: internal error code, arguments: [17069], [101534824], [], [], [], [], [], [] Any idea what mistakes I have done?

This may be due to bug in forms 6i.You need to resolve it. Kindly connect to metalink.oracle.com and go to the patch-section for downloading the patch 17 and install it. If you don't have metalink account you can create a metalink account. Go in metalink on the registration and fill out the form with the data of your software license Refer for more information The problem is using dual in oracle forms As a workaround you can try to create a plsql procedure in database create or replace procedure pr_increment_sequence(p_increment OUT NUMBER) is begin select customers_seq.nextval into p_increment from Dual; end pr_increment_sequence; and the below code in Oracle forms declare v_no number; Begin pr_increment_sequence(v_no);:Buyer_Entery_table.serial_number:= v_no; end.

The Oracle9i installation guide included in last month's Installation Cookbook series established the concept of applying an installation methodology to Oracle products. This cookbook article on installing Forms & Reports 6i (on a Solaris system) illustrates the same methodology. 'But wait, I'm a DBA, not a software installer,' so you say. True, you may be the DBA, but whom else to turn to when it comes to anything having to do with Oracle? More often than not, the DBA owns everything related to Oracle, whether or not the DBA has anything to do with that 'other' Oracle stuff. Additionally, it is not uncommon to find people working in DBA/developer positions, so shake off the narrow-minded view about what a DBA does and expand your knowledge of Oracle's installation process.

The previous article included a suggested outline of the installation process. You will find that when it comes to Oracle products, database or otherwise, the outline works just the same. A general outline of installation steps The seven steps shown below are the same steps from the Oracle9i installation cookbook.

• Windows XP: Click Add or Remove Programs. • When you find the program Harris Falcon III Radio Programming Application, click it, and then do one of the following: • Windows Vista/7/8: Click Uninstall. Harris unity radio programming software. • On the Start menu (for Windows 8, right-click the screen's bottom-left corner), click Control Panel, and then, under Programs, do one of the following: • Windows Vista/7/8: Click Uninstall a Program.

1.      Verify that hardware and software minimums are met or exceeded 2.      Prepare or update the operating system 3.      Create administrative/owner accounts and file structures 4.      Reserve, specify, or designate disk space 5.      Start the Oracle Universal Installer (OUI) and provide information as necessary 6.      Perform post-installation tasks 7.      Test your installation The first four steps can be considered as pre-installation tasks, step five as THE installation task and steps six and seven as post-installation tasks. Moreover, as I stated in the previous article, I like to include an introduction along with a list of assumptions or standards, and a list of references from which the information was drawn. As an added bonus, you can include a short troubleshooting section at the end of the installation guide.