Oracle Developer 6i & Oracle database 11g R2 (11.2.0.1.0)

 

A default installation of 11g R2 11.2.0.1.0 may not be very pleasant for Oracle developers who are still working with Developer 6i suite!

Our test lab installation has by default taken “NLS_CHARACTERSET AL32UTF8” as default database character set and we were unable to connect to the database from Developer 6i components like forms and reports.

As a workaround, we dropped the database and re-created it using database character set “WE8MSWIN1252” and later with “AR8MSWIN1256” as we needed Arabic support

An interesting discussion could be found here about the character set

Now, we are able to connect to the database, continue our development using developer 6i

Note: Please consult Oracle prior applying such workaround solutions to production environments. Our main intention was to find out a method to connect to 11g R2 database from Developer 6i products.

 

 

Regards,

admin

 

 

Advertisements

21 thoughts on “Oracle Developer 6i & Oracle database 11g R2 (11.2.0.1.0)

    1. You are welcome James :)
      We do hope that you read the Oracle forum thread, linked to this post. If you haven’t, please do.
      Experts have much to talk about workaround solutions there.

      regards,
      admin

  1. imran

    Hi Admin,

    how can we change the character set from WE8MSWIN1252 to AR8MSWIN1256 after creating the database? please help on this.

    Regards,
    Imran

  2. Arvind

    can you give detailed setting of ora files for connecting forms 6i and database 11gR2 please, because i am not able to conenct them.

    1. Hello Arvind
      If you are not on a production instance, drop the database and create a new one with a different character set other than NLS_CHARACTERSET AL32UTF8.
      This should let developer 6i products to connect to 11G. Please note, if you have developer 6i installed in Wondows 7 onwards OS, You will not able to achieve all the functionalities.

      Regards,

  3. Salman

    I need your technical guidance related to Urdu Language Support in Oracle Forms & Reports 6i.

    Below are the details of requirement and R&D effort we made to achieve the desired output:

    Requirement:
    ============
    We have an application in Oracle Forms & Report 6i and Database 10g Rel 2.
    There is a client requirement to provide Urdu support in this application. We have to enter Urdu data in few forms and print it in PDF reports.

    Problem:
    ===========
    We created new database with AL32UTF8 Character Set with same National Character Set for Unicode support.
    Developed a form and report on a table with NVARCHAR2 data type.
    Edited nls_lang entries in Registry to AMERICAN_AMERICA.AL32.UTF8
    Installed Urdu Support in WinXp
    Database stores and retrieves Urdu and displays Oracle SQL Developer.
    Oracle form stores/retrieves Urdu characters but it fails to type complete words and sentences.
    On typing 2nd, 3rd characters of a words all characters position mix up randomly and produce garbage.
    Oracle report don’t show Urdu characters in run-time but it shows the same in Report Builder.

    Please suggest solution of the above stated problems.

      1. Salman

        I still trying to resolve it but not success. Could your please update me step by step solution in Forms6i level and Database level.

        thank you for your reply.

      2. Hello there
        Setup registry values for both database, forms NLS language as AMERICAN_AMERICA.AR8MSWIN1256
        Make sure your client computers have the same language settings in the registry and Urdu keyboard language is enabled
        Arabic being the closest to right to left input, this should resolve your issues

        Unfortunately, I am not familiar with Urdu, however the above said always worked for our Arabic support.

        regards,

      3. Salman

        Yes. at the time of typing its show in URDU / ARBIC language. But When I Saved and Make Query. Its Shows Mixing of difference characters.

      4. Well, the screen shot is from a queried screen. The data is committed to the database. Please check your yahoo email given with the comment. I sent you a email asking for some details.

      5. Salman

        waaoooooo. Its not showing from my side. My Side is as per following:

        CUS_NAME_U
        ——————————————————————————–
        ¿¿¿¿¿¿¿¿¿ ¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿ ¿¿¿¿¿¿ ¿¿¿¿
        ¿¿¿¿¿¿¿¿ ¿¿¿¿¿¿¿¿ ¿¿¿¿¿¿¿ ¿¿¿¿ ¿¿¿¿¿¿¿ ¿¿¿¿¿¿ ¿¿¿¿¿¿¿¿¿¿
        ÔÁÆÃ
        ÁÚÇÏÚÑ Ç¿ ¿ÑÀÁ¿ Ý ¿ÀÿÇÄÀÚÓ

    1. Hi again
      You are asking to help with products those are obsolete from a decade and more (Minimum forms 6i). I doubt many forums, the younger creed of developers know anything about client server architecture and developer 6i. Urdu being used, most probably only in Pakistan, your chances to get specific instructions for the said language is going to be very difficult. However, if I could recollected Oracle communities had few queries about setting up Urdu. I’m not promising anything, it is too early. My colleague is a Pakistani and if I get enough time to setup a test environment, I will try to help you.

      regards,

  4. Pingback: Installation Oracle, Forms 6i on Windows 10 64 bitphporacle

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.