ORA00923 Derived Field Error 1

[abowling]

Hello,
I am receiving the following error:

ORA00923 Keyword FROM not found where expected.

Here is my derived field:

DECODE("PS_LOCATION_TBL"."LOCATION",
'REMOT' ,'Other U.S. Location',
'AZTEM', 'Tempe',
'CAIRV', 'Irvine',
'CASF', 'San Francisco',
'FLSUN', 'Sunrise',
'LANO', 'New Orleans',
'MDSS', 'Silver Spring',
'NHSAL', 'Salem',
'NYAST', 'Astoria',
'NYNY' , 'New York',
'OHCOL', 'Columbus',
'TXDAL', 'Dallas',
'TXHOU', 'Houston'))))))))))))))

Any idea what this means?

 

[abowling]

Nevermind - I just figured it out. It was conflicting with another Derived Field I had in the report.

 

[CharlesCook]

DECODE("PS_LOCATION_TBL"."LOCATION",
'REMOT' ,'Other U.S. Location',
'AZTEM', 'Tempe',
'CAIRV', 'Irvine',
'CASF', 'San Francisco',
'FLSUN', 'Sunrise',
'LANO', 'New Orleans',
'MDSS', 'Silver Spring',
'NHSAL', 'Salem',
'NYAST', 'Astoria',
'NYNY' , 'New York',
'OHCOL', 'Columbus',
'TXDAL', 'Dallas',
'TXHOU', 'Houston')))))))))))))) <================

Why so many end quotes?

CharlesCook.com
Specializing in ReportSmith Training and Consulting