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

December 16, 2012

 

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

 

 


Oralce apps reports, instance producing gibberish character mapping

July 11, 2010

We are @ the final stage of implementing Oracle e-business suit 12 and recently came across a peculiar font mapping problem with custom developed reports. We use both Developer 6i reports developer as well as 10g reports developer.
Once the reports are tested and uploaded to the apps instance, the outputs were always producing gibrish (PDF outputs especially). However after few days of experimenting, finally we found a work around (hopefully)!

Following are the tips:

Design your report, test it.
Do not change the default font until your report is ready to upload to the instance.

Now decide the actual font you need to use with your final report.
And never select the font from the font list drop down, check the image:

Instead click on format menu item, select “font” and choose your font. Generally we use Courier New or Times New Roman (Western) for our reports and this method has solved our months long troubles with the reports. Please check the attached image:

When you need to change the font sizing and weight for individual items, follow the same method and once you are satisfied with the layout upload to the apps instance.
We hope this work around is helpful for few out there.

Windows7bugs team


Follow

Get every new post delivered to your Inbox.

Join 45 other followers