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
add comment

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.