Article - CS136858
When trying do get a numeric value from oracle database using sql function TO_CHAR exception java.sql.SQLException occurs in Windchill PDMLink (Customization)
Modified: 10-Dec-2020
Applies To
- Windchill PDMLink 10.1 to 11.1
Description
- When trying do get a numeric value from oracle database using SQL function TO_CHAR exception java.sql.SQLException occurs
- It seems that OrcaleDMLGenerator forces TO_CHAR function to use 'dd mm yyyy hh24:mi:ss' format pattern
- The statement: wt.query.SQLFunction.newSQLFunction(wt.query.SQLFunction.TO_CHAR, classAttribute); fails with :"java.sql.SQLException: ORA-01481: invalid number format model"
This is a printer-friendly version of Article 136858 and may be out of date. For the latest version click CS136858