Hi
I Put in code procedure is
DBMS_APPLICATION_INFO.SET_ACTION('RUNNING#'||v_usuario_synchro)
When other user try to access same procedure , I use code below
SELECT ACTION
FROM V$SESSION
WHERE ACTION LIKE 'RUNNING%'
AND STATUS = 'ACTIVE';
How can I to get only username( after word RUNNING and some character), I tried to use # to serp the name, but I was told that the username can start with any character
I Would like example:
'RUNNING##XPTO' ==> returning '#XPTO'
''RUNNING#DUCK' ==> return 'DUCK'
Using
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
PL/SQL Release 11.2.0.4.0 - Production
CORE 11.2.0.4.0 Production
TNS for Linux: Version 11.2.0.4.0 - Production
NLSRTL Version 11.2.0.4.0 - Production