Patch for Bug 4554072:SUPPRESS CONTENT-LENGTH IF DAD CHARSET <> DB CHARSET
--------------------------------------------------------------------------

* Patch is applicable only for the following PL/SQL Web Toolkit(OWA) versions:
   For 3.0.9 series: 3.0.9.8.5 
   For 9.0.4 series: 9.0.4.0.2, 9.0.4.0.3, and 9.0.4.0.4
   For 10.1.2 series: 10.1.2.0.0 and 10.1.2.0.2
    
   If the PL/SQL Web Toolkit version is lower than the versions mentioned above,
   applying July 2005 Critical Patch Update(CPU) or later will bring the 
   PL/SQL Web Toolkit package version to the required version for this patch.


* WHEN TO APPLY THE PATCH:
   Make sure that the database instance meets the requirements of
   PL/SQL Web Toolkit versions as indicated in the above section.
   
   To find out the PL/SQL Web Toolkit version, connect to the database as sys  user
      sqlplus "/ as sysdba"
       SQL> select owa_util.get_version from dual;

* WHEN TO RE-APPLY THE PATCH:
   If you apply any database patchset or Application Server patchset 
   in which the patchset recommends installing PL/SQL Web Toolkit packages, this
   patchset can be overwritten. In such situations, you can reapply
   the patch after applying the database/Application Server patchset.

   For example, this one off patch will be overwritten by any of 
   the following:-

     1. CPUs: July 2005, October 2005
     2. Application Server 9.0.4.2 patchset


* WHEN NOT TO APPLY THE PATCH:
   Future releases of database and Application Server will include this patch.
   In those cases the patch should not be applied, since applying 
   this patch would overwrite any other fixes that may have been included 
   in that release or patchset. Please check the corresponding patchset
   note for the list of the bug fixes.
  
* HOW TO APPLY THE PATCH:
   - Extract the contents of the patch to a temporary directory
   - Bring down all the applications using the Database
   - Backup the pacakges htp and htf by running htp_htf_backup.sql as sys user
      SQL> @htp_htf_backup.sql
                   OR
     Follow the database patch backup procedure.
     NOTE: htp_htf_backup.sql script generates htp_htf_restore_<SID>.sql script
           which can be run if you want to deinstall the patch. Be sure to
           save it in a location that you could accees later for deinstallation.
           If you run htp_htf_backup.sql more than once it will overwrite
           the current restore script with the name htp_htf_restore_<SID>.sql  
           Be sure to change the permissions of the script  htp_htf_restore_<SID>.sql
           to prevent accidental overwrites of your backup.

   - Login to the database instance that needs to be patched up as sys 
       sqlplus "/ as sysdba"
   - If the PL/SQL Web Toolkit version is in 3.0.9.8 series, run
        SQL> @@309x/privht.sql
        SQL> exit

   - If the PL/SQL Web Toolkit version is either 9.0.4 series or 10.1.2 series and 
     the database version is 8.1.7.4
        SQL> @904x_1012x/privht8.sql
        SQL> exit

   - If the PL/SQL Web Toolkit version is either 9.0.4 series or 10.1.2 series and 
     the database version is higher than 8.1.7.4
        SQL> @904x_1012x/privht.sql
        SQL> exit

* How to deinstall the patch
   - If you ran htp_htf_backup.sql before applying the patch, locate htp_htf_restore_<SID>.sql
     and run it by connecting to the database instance with the same SID as sys 
                OR 
     Follow database restore procedure.

* Number of files in the patch: 5(five)

  README.txt(this file),  
  htp_htf_backup.sql, 
  309x/privht.sql , 
  904x_1012x/privht8.sql,  
  904x_1012x/privht.sql