Windows Oracle Data Access Components (MOSC)

MOSC Banner

How do I specify columns defined by the SQL "AS" keyword in the Entity Data Model?

edited Dec 5, 2013 9:04AM in Windows Oracle Data Access Components (MOSC) 3 commentsAnswered
I have an SQL statement that contains an AS clause to define a resulting column in the query.  For example:

SELECT LAST_NAME, FIRST_NAME, TRIM(FIRST_NAME || ' ' || LAST_NAME) AS FULL_NAME FROM TABLE1

Obviously FULL_NAME doesn't exist in the database, only in the query. I tried adding the column FULL_NAME to the table in the entity data model, but when I ran the query I got the message:

The data reader is incompatible with the speciified 'MODEL.TABLE1'. A member of the type, 'FULL_NAME', does nto have a corresponding column in the data reader with the same name.

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.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center