As I am using a union query I need to convert text fields to nvarchr (Max)
The statement works well in Studio manager but in FME the attributes are <missing> despite using AttributeExposer.
Without union clause the text fields display as expected using AttributeExposer so i feel certain it is the cast as Nvarchar(max) that is causing the problem.
How do I resolve this ?
Unless you've already done so, you will have to specify the name the resulting column, e.g.
select cast(fieldname as nvarchar2(max)) as fieldname
from...Otherwise the output column will actually be called "CAST(FIELDNAME AS NVARCHAR2(MAX))"
This is standard Oracle behavior, by the way.
Sorry for the delayed response , but yes thank you that was the answer it needed to know the fieldname