I am trying to get the web application user ID in a trigger for auditing purposes. ID is setup in the connection when it is retrieved as follows.
*String metrics = new String[OracleConnection.END_TO_END_STATE_INDEX_MAX];*
And is retrieved in the trigger as SELECT sys_context('USERENV','CLIENT_IDENTIFIER') INTO usrId FROM DUAL;
This works fine in tomcat and weblogic. But not in OAS. Any ideas?