Take the 2-minute tour ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

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.

UPDATE
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

 
discard

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

Browse other questions tagged or ask your own question.