[WayneClements]

Does anyone know why a simple select like :

SELECT SettingValue FROM sysCONFIG_SETTINGS 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

Expand|Select|Wrap|Line Numbers

1. SELECT SettingValue FROM sysCONFIG_SETTINGS WHERE ModuleName = 'N''ScheduledTask''' AND SettingKey = 'N''Logon'''