Issue with CLOB fields in HCM 8.55 installation

 

We are trying to create a Tools 8.55 HCM Demo database using the Database Configuration Wizard. We are in Step 7.2.10 (Complete Database Setup) of the PeopleTools 8.55 install guide. We copied the pt84tblspc App Designer project and built it to create the corresponding SQL script. When we run the script, it abends on any insert that has a Long or CLOB source if there is data in the original table regardless of whether there is data in the field. The error message is: ORA-00997: illegal use of LONG datatype. Please note that our 9.2 HCM database was built with PeopleTools 8.53.

 

Below is the CREATE statement that works and the INSERT/SELECT statement that gets the ORA-00997 error.