PeopleTools and Lifecycle Management - PSFT (MOSC)

MOSC Banner

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:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center