====================================================
Notice to Autodesk Productstream Customers
====================================================

In a continuing effort to provide high quality products, Autodesk has released this 
hotfix which affects Productstream Professional 2009 running in an Oracle database.


This README file highlights how to install this hotfix, and other important 
information regarding this update.


====================================================
CONTENTS
====================================================

- Description of the issue
- System Requirements
- Known Issues
- Warnings
- Files Affected
- Update Verification
- Installation Instructions


====================================================
Description of the issue:
====================================================

The DBP function GetMaxKey() does not correctly when Productstream Professional is
installed in an Oracle database. This is because the stored procedure function
adsk_get_maxkey does not return any results.

The solution is to replace the stored function in the database with the corrected
one included in this hotfix.

====================================================
System Requirements:
====================================================

Productstream Professional 2009
Oracle Database 


====================================================
Known Issues:
====================================================



====================================================
Warnings:
====================================================



====================================================
Files Affected:
====================================================

ADSK_GET_MAXKEY.SQL

====================================================
Update Verification:
====================================================


====================================================
Installation Instructions:
====================================================

Copy the SQL file from the zip file to a known location,
for example C:\temp

Use SQLplus or a similar tool to connect to the Oracle database.

Connect as the Productstream Professional schema owner and run the SQL file.
Don't forget to terminate operation by entering the / character.

> sqlplus <psp_schema>\<psp_schema_password>@<oracle sid>

SQL> @c:\temp\ADSK_GETMAXKEY.SQL
SQL> /

You should now see a message:

"Function created."

After installing this function the DBP function GetMaxKey will work correctly.

================================================================================

Thank you for your commitment to Autodesk products.

Respectfully,

Autodesk Data Management Team