Oracle Forms Builder 11g Main Screen

Once the appropriate menu item has been clicked on (for Windows), the Oracle Forms Builder Object Navigator will appear. . Note that the Oracle Forms Builder screen has remained virtually unchanged between Versions 9i, 10g and 11g. After starting up Oracle Forms, the main screen will be presented. The menu bar across the top provides […]

Oracle Forms and Reports 11g Starting Information

nstallations for Oracle 10g Developer and Oracle 11g Forms and reports should have similar Oracle Home start menu items. For example, the Oracle 11g Forms and Reports is installed on top of the Oracle Fusion Middleware (also called Weblogic Server) and has the following Start menu items: To run the Oracle 11g Forms Builder under […]

Oracle 9i, 10g and 11g Developer Suite Tools

Oracle Developer Suite contains the following main components: Oracle 9i, Oracle 10g and Oracle 11g Forms – For designing data entry forms. Oracle 9i and Oracle 10g Reports – For designing reports. Oracle 9i, 10g or 11g JDeveloper – For developing Java applications or applets Oracle 9i, 10g or 11g Warehouse Builder and Discoverer – […]

Oracle 9i, Oracle 10g and Oracle 11g Developer Suite Forms and Reports Prerequisites

Before following this tutorial, a student must have a valid user account in an Oracle server or a local installation of an Oracle database. Contact your DBA or systems administrator to learn the details of how Oracle server is set up in your organization. If you have a local instance of the Oracle database, please […]

Introduction To Oracle 9i / 10g / 11g Developer Suite Forms and Reports Tutorial

This tutorial introduces the Oracle 9i, Oracle 10g and Oracle 11g Developer Suite Release 2 that includes Oracle Forms and Oracle Reports. The main objectives are to demonstrate and provide hands-on instructions for creating and modifying data entry and query forms in various configurations, reports and graphics. Caveats: I have been working on this tutorial […]

OracleAtoZ SMS Gateway (Send/Received SMS by using Oracle)

OracleAtoZ SMS Gateway is very useful for many organizations that are dealing with Complains Management System. By using OracleAtoZ SMS Gateway you can Send/Received complain solving SMS messages directly into your Oracle Database. Many organizations that are dealing with customer services like CRM Related Companies, Telephone Companies , Dish TV Companies , Cable TV Network […]

How to send Email in Oracle using Gmail.

oracle-gmail_head

Email sending by using Oracle through Gmail: In oracle we can send email by using two ways. 1- Send Email through Gmail 2- Send Email through Email Exchange server. In this post we will know how to send email by using oracle through gmail. Small compnies can not purchase and manage exchange serves so they […]

What is Oracle Virtual BOX

VirtualBox may be a powerful x86 and AMD64/Intel64 virtualization product for enterprise furthermore as home use. Not solely is VirtualBox a particularly feature made, high performance product for enterprise customers, it’s conjointly the sole skilled resolution that’s freely accessible as Open supply software system underneath the terms of the wildebeest General Public License (GPL) version […]

Chapter No.10 How to save the data in database in Oracle?

In this chapter we will store the data in oracle database. In Chapter No.6 we have designed a form by using oracle forms builder with wizard.  We will store a data of these fields in database now. As we know that we are already created tables in database in Chapter No. 2. Open a form […]

Chapter No.9 Form Item Property

Every item on Oracle Forms Builder has its unique properties.  We can change these properties according to our need of the application. In this chapter we will discuss some important and most usable properties of items.   Tab Property Name Description General Name Use for give proper Item Name Item Type Text Item/List Item/Radio Group […]

Chapter No.8 Form Data Block Property

<<Previous Chapter                                                    Next Chapter>> We are discus here some important properties of Oracle Forms Builder. We can change these properties of block as per need. If we press “F4” on any Block then we will see these properties that are given below. We are here discussing only most useable properties.   Tab Property Name Description […]

Chapter No.7 Detail of Form Canvas, Block and Items

<<Previous Chapter                                                    Next Chapter>> In previous chapters we learn that how to draw the items on canvas. In this chapter we will learn about Canvas, Block and Items. In this pitcher you see that there are different objects of the form. If we want to see “Property” of any object just selects this object and […]

Chapter No.6 Make Database Block with wizard on Canvas

<<Previous Chapter                                                    Next Chapter>> In this chapter we will make Database Block by using Data Block Wizard. By following these steps we can create Database Block on canvas very easily. For Creating Data Block: Click on “Data Blocks” under the forms hierarchy. Then Click on “+” sign on left side for creating new Database Block. […]

Chapter No.5 What is Block in Forms Builder?

<<Previous Chapter                                                    Next Chapter>> What is Block in Oracle Forms Builder? Block is an area where we put all the items in it. Block is a container we put all the items in it but on Canvas we show up these items. Suppose we have five items in Block then we can show all items […]

Chapter No.4 How to draw a Canvas on form?

<<Previous Chapter                                                    Next Chapter>> Canvas is an area of Oracle Form Builder like a ground area where we draw different items on canvas. Like Text Item, List Item, Radio Button, Image and etc… By following these steps you can draw a canvas on form. Click on “Canvas” that is under the hierarchy of Form. Press […]

Chapter No.3 Just Start with the New Form

<<Previous Chapter                                                    Next Chapter>> We will create new form in Oracle Form Builder by following these steps. Go to” FILE” menu then click “NEW” then click “FORM” A new form will create with default name “module” Save this form on any location. This form will save with extension “.FMB” When we compile this with (CTRL+T) […]

Chapter No.2 Make Tables in Oracle Database for Development

<<Previous Chapter                                                    Next Chapter>> We will develop “Inventory Control System” step by step by using Oracle Forms Builder. We will Create necessary table for this system. Supplier Table, Transaction Master Table and Transaction Detail Table. Just run copy these tables script and draw tables in Oracle Database.   –Supplier Table CREATE TABLE SUPPLIER_INFO ( SUPP_ID […]

Chapter No.1 Introduction of Oracle Form Builder

Next Chapter>> Oracle Form Builder is using for making data entry form or screens. By using Oracle Form Builder we can make any type of data entry screen that will use for any purpose. Basically there are three main things that we will use to develop the application. First Oracle Database that is using for […]

Oracle Error Codes (ORA-01001 to ORA-01915)

ORA-01001: invalid cursor ORA-01002: fetch out of sequence ORA-01003: no statement parsed ORA-01004: default username feature not supported; logon denied ORA-01005: null password given; logon denied ORA-01006: bind variable does not exist ORA-01007: variable not in select list ORA-01008: not all variables bound ORA-01009: missing mandatory parameter ORA-01010: invalid OCI operation ORA-01012: not logged on […]

Oracle Error Codes (ORA-00601 to ORA-00999)

ORA-00601: cleanup lock conflict ORA-00602: internal programming exception ORA-00603: fatal ORACLE error occurred; unwise to proceed ORA-00604: error occurred at recursive SQL level num ORA-00700: maximum number of row cache object (parameter ‘name’) exceeded ORA-00701: object necessary for warmstarting database cannot be altered ORA-00702: maximum number of row cache enqueues exceeded ORA-00703: maximum number of […]

Oracle Error Codes (ORA-00446 to ORA-00600)

ORA-00301: error in adding log file ‘name’ – file cannot be created ORA-00302: limit of num logs exceeded ORA-00305: log ‘name’ inconsistent; belongs to another database ‘name’ ORA-00306: limit of num log writer instances exceeded ORA-00308: cannot open offline log‘name’ ORA-00309: offline log belongs to wrong database ‘name’ ORA-00310: offline log ‘name’ contains sequence num; […]

Oracle Error Codes (ORA-00000 to ORA-00300)

ORA-00000: normal, successful completion ORA-00001: duplicate key in index ORA-00014: there no session number num in this process ORA-00017: maximum number of calls exceeded ORA-00018: maximum number of sessions exceeded ORA-00019: maximum sessions per process (num) exceeded ORA-00020: maximum number of processes (num) exceeded ORA-00051: timeout occurred while waiting for resource ORA-00052: maximum number of […]

How make LOV in oracle forms builder?

You can make LOV step by step 1- Open form builder draw two fields 1st filed name “UOM_ID” and second field name “UOM_NAME” 2- Just Click on LOV option in list and click on green “+” button for new. 3- Click next and write the query in it. 4- select fields in it by using […]

Oracle Database Questions & Answers 3

61. What constitute an ORACLE Instance ? SGA and ORACLE background processes constitute an ORACLE instance. (or) Combination of memory structure and background process. 62. What is SGA ? The System Global Area (SGA) is a shared memory region allocated by ORACLE that contains data and control information for one ORACLE instance. 63. What are […]

Oracle Database Questions & Answers 2

What is Network Database link ? Network database link is created and managed by a network domain service. A network database link can be used when any user of any database in the network specifies a global object name in a SQL statement or object definition. What is Data Block ? ORACLE database’s data is […]