Patch Name:  PHSS_3486

Patch Description: s300_400 9.0 Softbench SQL patch for sqlprescan coredump

This patch is required for compiling large Oracle programs with Softbench SQL
and all versions of Oracle 6.X and 7.X.

Programs affected: sqlprescan

Problem for which the SR was filed against the product:

sqlprescan would coredump when it encountered an SQL sequence that was
greater than 2KBytes in length.  This was due to a buffer overflow.

Fix:

This version of sqlprescan simply parses each SQL sequence for information
that is relevant rather than reading the entire contents of each sequence
into the buffer.  This eliminates situations for buffer overflow, regardless
of how long the sequence is.

Path Name:  /hp-ux_patches/s300_400/9.X/PHSS_3486

Effective Date:  93/12/08

OS Release:  9.00

Reboot Required:  No

Patch Files:  sqlprescan

SR#:  5000702175

"what" string/timestamp:  

sqlprescan:
        REV: 931207, 9000/385 HP-UX B.08.00 masonbld@hpfcbld

"sum" output:  

19609 18 sqlprescan

Dependencies:  None

Supersedes:  None

Patch Package Size:  72 Kbytes

Installation Instructions:  

     Please review all instructions and the Hewlett-Packard
     SupportLine User Guide or your Hewlett-Packard support terms
     and conditions for precautions, scope of license,
     restrictions, and, limitation of liability and warranties,
     before installing this patch.

     Note: Please back up your system before you patch.

---------------------------------------------------------------------------
After getting the patch onto your machine, unshar the patch (sh PHSS_3486).

To install this patch do the following:
1) Run /etc/update (Note: you must be logged in as root to update
   a system).
2) Once in the update "Main Menu" move the highlighted line to "Change
   Source or Destination ->" and press "Return" or "Select Item".
3) Make sure the highlighted item in the "Change Source or Destination"
   window is "From Tape Device to Local System ...", then press "Return" or
   "Select Item".
4) You should now be in the "From Tape Device to Local System" window.
   Change the "Source:  /dev/rmt/0m" to "Source: /tmp/PHSS_3486.updt"
   (this assumes that you are in the /tmp directory where PHSS_3486.updt
   has been placed).  Note: You must enter the complete path name.
5) Press "Done".
6) From here on follow the standard directions for update.

The customized script that update runs will move the original software
to /system/PHSS_3486/orig.  HP recommends keeping this software there in
order to recover from any potential problems.  It is also recommended that
you move the PHSS_3486.text file to /system/PHSS_3486 to be retained for
future reference.

If you wish to put this patch on a magnetic tape and update from the tape
drive, dd a copy of the patch to the tape drive.  As an example the
following will create a copy of the patch that update can read:
dd if=PHSS_3486.updt of=/dev/rmt/0m bs=2048