Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Using sdequery, I'm specifically trying to return sys_context('USERENV', 'SESSIONID'). user and sysdate work fine. Functions with single parameters work fine.

But as soon as I use a function with multiple parameters, I get: Error: Stream not found (-107). The SDEINTERCEPT shows the query columns as 2 columns (split at the comma). Makes sense since the comma is usually a column delimiter, but how do you escape commas that aren't delimiters?

I've tried preceding the comma with a backslash. Double commas. Wrapping the entire thing in double quotes. Wrapping the comma in various quote combinations.

USERENV('SESSIONID') works and gives me what I need, but I'd still like to know if/how you can escape the comma for future reference.

share|improve this question

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.