Discussions
Receive Error When Adding Expression To Union Query: SQL Error, Code=1790, Message=ORA-01790: expre
edited Aug 8, 2014 4:00PM in PeopleTools and Lifecycle Management - PSFT (MOSC) 4 commentsAnswered ✓
I am trying to do a Union in PeopleSoft Query. I needed to add expressions in order to have the correct number of fields in the second query. The first query had 10 fields and the second one only had 8. In Query2 each expression has ‘’ in the expression text and each has the same Expression Type and Length as its related field from Query1. Each expression is used as a field and is in the same order as the actual field from Query1.
The error message “SQL Error, Code=1790, Message=ORA-01790: expression must have same datatype as corresponding expression (50,380)” is received.
Tagged:
1