Advertisement
Guest User

Untitled

a guest
Mar 16th, 2012
120
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.85 KB | None | 0 0
  1. UPDATE GLOBALSETTINGS
  2. SET settingValue = case
  3. when settingName = 'SessionTTL' then '40'
  4. when settingName = 'MaxUsersActive' then '50'
  5. else settingValue
  6. end
  7. WHERE settingName in ('SessionTTL', 'MaxUsersActive');
  8.  
  9. //The result:
  10.  
  11. Error starting at line 1 in command:
  12. UPDATE GLOBALSETTINGS
  13. SET settingValue = case
  14. when settingName = 'SessionTTL' then '40'
  15. when settingName = 'MaxUsersActive' then '50'
  16. else settingValue
  17. end
  18. WHERE settingName in ('SessionTTL', 'MaxUsersActive')
  19. Error at Command Line:7 Column:6
  20. Error report:
  21. SQL Error: ORA-00904: "SETTINGNAME": invalid identifier
  22. 00904. 00000 - "%s: invalid identifier"
  23. *Cause:
  24. *Action:
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement