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.
