SELECT WHERE SettingKey = N'Logon' FAILS

[WayneClements]

Does anyone know why a simple select like :

SELECT SettingValue FROM sysCONFIG_SETTI NGS WHERE ModuleName = N'ScheduledTask ' AND SettingKey = N'Logon' should fail in oracle 10g

It fails with 'no such column'

It works is I use N'Logonxxx' or 'Logon'

And it works in SQL+ and SQL/Developer

But it fails in the live system

Thanks

[debasisdas]

try using this

[code=oracle]
SELECT SettingValue FROM sysCONFIG_SETTI NGS WHERE ModuleName = 'N''ScheduledTa sk''' AND SettingKey = 'N''Logon''' [/code]