When utilizing functions like set_context and sys_context in databases like Oracle, the information returned is different in each call in PowerServer. For instance, the sessionid obtained in the following script may differ each time in PowerServer.
SELECT SYS_CONTEXT('userenv', 'sessionid') into :ll_session from dual using sqlca;Cause & Solution: Refer to Enabling long connections.
