Oracle Forms 10G Installation For Oracle Designer

Oracle Forms 10G Installation

 On Windows 8.1 & Windows 10 64 bit

 In the name of Allah, Most Gracious, Most Merciful

Praise be to Allah, blessing and peace be upon our prophet Mohammed, his family and his companions. After that,

              Oracle  Developer Suite 10G still compete with Oracle Developer Suite 11g & 12c in regard to its convenient installation and common configuration. Although, Oracle no longer supports Oracle Developer Suite 10G but, it involves the latest Oracle Designer available for download at Oracle Official Site. 
     

       The significant installation problem is a compatibility problem. Oracle Developer 
Suite 10G is  no longer compatible with the new OS as Microsoft Windows 8.1 
 The need for Oracle Designer never stops and the client's old applications still running. These were two reasons to illegally create some work around.
  (May Allah Forgive Us ) to cope with the new Operating System.  

Task Definition:   

    Oracle Developer Suite 10G Installation for Oracle Designer. On Windows 8.1 64 bit

Oracle Form 10g Test Form 

(Not Running)

In the name of Allah, Most Gracious, Most Merciful

Praise be to Allah, blessing and peace be upon our prophet Mohammed, his family and his companions. After that,

      In regards to Oracle Forms 10G Installation, you may face some errors.

You have to consider dealing with it but not reinstall it over the old copy.

  Problem Definition:   

       you may had a successful Oracle Forms 10G Installation afterwards you were unable to run the form. The following error message stuck the form running.

Task Solution 

1.     Use  Java 6 or Java 7

it is Certified with Forms and Reports 10g.

2.     Modify url: http://pc_name:Port/forms/frmservlet?config=test

e..g.  http://Amatu_Allah:8889/forms/frmservlet?config=test

3.     Create a working directory on default.env file FORMS_PATH=c:\DevSuiteHome_1\forms;

Hope this helps...

 Learn more about:

•          The Best 3 Steps For Handling Oracle Forms Messages
•          OracleForms Errors & Informative English Script Messages
•          Oracle Form Global Variable Recognition
•         In-Direct Global Variable Access
•         MenuItem Enable/Disable

My success only comes from Allah, pls. note your comments and suggestions are great help for me in progress thanks in advance.

Customizing Oracle Forms Errors & Informative Messages In English

Customizing Oracle Forms 
Errors & Informative Messages In English

In the name of Allah, Most Gracious, Most Merciful

Praise be to Allah, blessing and peace be upon our prophet Mohammed, his family and his companions. After that,

According to the previous blog i had created to share my experience regarding:
The Best 3 Steps Handling Oracle Forms Messages,
 I was inspired by Allah swt for creating the following data script to facilitate customizing Oracle forms informative and error messages in English Language.

PDE-PLI018 Could not find library NAME

PDE-PLI018 Could not find library NAME

In the name of Allah, Most Gracious, Most Merciful

Praise be to Allah, blessing and peace be upon our prophet Mohammed, his family and his companions. After that,

     

     The skills gained from experienced such development errors; Googling  for a solution, ask a professional friend, leads you to successfully climb the ladder of experience. Employers are often looking  for a value you can add to hire you. 

     Normally, experience does not come easily, as long as you work on Oracle forms application development you would face a lot of compilation or run-time form's errors either begins with 'FRM' or  with 'ORA' database errors. These errors are common errors to large numbers of expert Oracle developers. 

      Accidentally, You may face such uncommon error begins with e.g. PDE-  pop up for you on opening such Pl/SQL Library from Oracle Form Builder. Today, i will demonstrate to you such uncommon error you should be familiar with ...

Key problem: 

  Error: PDE-PLI018 could not find library NAME

 When you try to open the library in the oracle forms builder it throws the above error even though the library is included in the path...

Key Reason:

  

   It's a  form 10g 's bug. 

When attempting to open a .pll from the Forms Builder using the login of the User who is not having the administrator privilege, the following error occurs: PDE-PLI018 could not find the library

Key Solution: 

      When attempting to open a .pll from the Forms Builder using the login of the User who is not having the administrator privilege, the following error occurs: PDE-PLI018 could not find the library.

•  The simplest solution for this bug is you should have OS's administration rights so that you can login and Run The Form Builder As administrator .
•  This Bug is also included as part of the Patch Set 10.1.2.3 whereas for the Versions 10.1.2.0.2 and 10.1.2.2, One-Off Patch 2673271  has to be applied.

You can you check this form 10g's bug at My Oracle Support (MOS) document 602158.1

A Suggested working Solution to the problem. 

Hope this helps…

Learn more about: 

·         Calling Oracle Report from Oracle forms 6i

·        Generate Oracle Arabic Report 10g - PDF Format

·        In-Direct Global Variable Access

·        Centralize Oracle Window Forms 

·        Maximize Oracle Window Forms

  

My success only comes from Allah, pls. note your comments and suggestions are great help for me in progress thanks in advance.

خطـوات حــل مشكلـة توافــق برنـامج 10g Oracle Developer مع Windows 7 64 bit)

خطـوات حــل مشكلـة توافــق برنـامج  10g Oracle Developer Suite  

مع نظــام تشغيــل  Windows 7 (64 bit)

      بسم الله والصلاة والسلام على أشرف الخلق سيدنا محمد وعلى آله وصحبه وسلم، أما بعد...

   

     فإذا عزمت على تثبيت برنامج  مطور أوراكل إصدار 10 على نظام تشغيل ويندوز 7 (64 بت)، على جهاز  الكمبيوتر المحمول، فتوكل على الله ثم قم بمتابعة هذا المقال لتحقيق الإستفادة العملية والفنية قبل الشروع  فى تثبيت البرنامج.

عرض المشكلة

     ظهور رسالة خطأ غير متوقعة من جهاز الكمبيوتر المحمول أثناء بدأ عمل مثبت برنامج مطور أوراكل العالمى إصدار 10 جى Oracle Developer Suite 10g التثبيت على نظام تشغيل    Windows 7 (64 bit) وتكرر ظهور رسالة الخطأ كما بالصورة: 

سبب المشكلة

     إن السبب الأساسى فى رسالة الخطأ السابقة يرجع فى إلى مشكلة عدم التوافق بين ملفات نظام تشغيل ويندوز.dll وبرنامج مطور أوراكل 10 جى الذى سبق إصداره إصدار نظام تشغيل  .Windows 7 – (64bit)

The Best 3 Steps For Handling Oracle Forms Messages

The Best 3 Steps For Handling

Messages Oracle Forms 

In the name of Allah, Most Gracious, Most Merciful

Praise be to Allah, blessing and peace be upon our prophet Mohammed, his family and his companions. After that,

       One of the most critical application concerns for a developer and for an end users  is planning for handling application messages. Since, it reflects the quality of your code outputs is it buggy or it handles the end-users requirements effectively. 

   
      It is really embarrassing if  you are in the presentation at your customer's company explaining your wonderful program and one of the unpleasant informative or error messages popes up at your customer's face. Well, it's not the end of your career life, you can manage this situation tactfully. 
Let's limit the worries and start implementing a real reliable effective solution.

ask DefinitionT   

         

     Suppress Oracle Forms Informative & Error  Messages

Task Solution:

  Step One: 


     Create a database table for customizing your form errors as follow:

CREATE TABLE ERROR_MESSAGES

)

,MSG_CODE NUMBER (5, 0) NOT NULL Primary Key 

,MSG_TYPE VARCHAR2 (1) NOT NULL 

MSG_DESC VARCHAR2 (200) NOT NULL



; ( 

 Step Two:

    Run the following Ready Made English Messages Script  as a sample data of such common Oracle Forms Informative and error messages.

   

Step Three:

    Create On-Message and On-Error Triggers. Now, you paste the following optimized code into each trigger on form level with which you can handle the forms informative and error messages effectively.

DECLARE

        lv_errcod              NUMBER := ERROR_CODE;

       alert_message     VARCHAR2 (200);



  BEGIN



         SELECT msg_desc

         INTO     alert_message

         FROM   error_messages

         WHERE msg_code = lv_errcod ;



 EXCEPTION



         WHEN OTHERS THEN

       alert_message:=message_type||'-'|| To_Char(message_code)

 || ': ' ||  message_text;

 Raise Form_Trigger_failure;    

END;

        It's also a quite good idea to create a pl/sql library in oracle forms that includes a a procedure encapsulated in a pl/sql package with the previous code in order to  facilitate reusing the optimized code as an object in each form application.  

Learn More about:

• Informative English Messages Script 

My success only comes from Allah, pls. note your comments and suggestions 
are great help for me in progress thanks in advance.

 Forms 6i Icons Do Not Display on Windows 7 

  

     In the name of Allah, Most Gracious, Most Merciful

Praise be to Allah, blessing and peace be upon our prophet Mohammed, his family and his companions. After that,

    In respect to fulfilling customer's requests on a daily basis, your customer may ask you to make his old forms version application ' forms 6i' works on his laptop or his windows 7 work office PC.

Many issues you will face concerning compatibility between Oracle forms and Windows 7 operating system.

    The Oracle Form icons issue is a significant issue for your forms application. If your form icons do not display icon images, then your whole project will be stuck.

Key Problem: 

Oracle forms 6i Icons Do Not Display on Windows 7 version.

Key Reason: 

The reason of this issue is as a result of either the path of the form's icon parameter is Not Set correctly or it is not initially created before running your form.

   On the other hand, if you verified that your iconic parameter is exist and set correctly with the appropriate folder name and path, then most probably it's a compatibility issue of using such old form version with newer operating system version.

Key Solution:

·        Select Windows Start menu > Choose Run > enter regedit, and click OK.

·      Close all your Oracle forms.

·     Check that the UI_ICON is set correctly:

  

o   If your operating system "Windows7 32 Bit" then follow the Registry

 Path: "HKEY_LOCAL_MACHINE \ SOFTWARE \ ORACLE"

o   If your operating system"Windows7 64 Bit" then follow the Registry

 Path:"HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ORACLE"

o   Alternatively,  Search for UI_ICON key; Press F3

o   If  you found it Double click UI_ICON  key to open or edit it > copy the path of your image folder and reset  UI_ICON key the paths of your icon folder

o   If  not found then you have to manually Create a Registry Key string: UI_ICON

         o   Then Double click UI_ICON  key to set the correct path for your button icon images. 

·     Second, Search for the Oracle forms 6i executable file name: “IFBLD60.EXE”  right click the file under “File Properties“ -> “Compatibility”  tab : you have a check box option > “Run this program in compatibility mode” you had a check mark on this option during installation process to start; now you have to “uncheck” it.

·      Reopen your old Oracle forms 6i, you will be able to see your icons in Forms run-time.  

Note:

·        Client/server Forms uses the' .ico' format for icons.

·        Specifying the icon name in the property palette of your form; just put the 'open' not 'open.ico'.

Hope this helps…

My success only comes from Allah, pls. note your comments and suggestions are great help for me in progress thanks in advance.