1329: */
1330:
1331: FUNCTION get_session_process_id RETURN VARCHAR2 IS
1332: 1333: l_spid V$PROCESS.spid%TYPE; 1334:
1335: BEGIN
1336:
1337: SELECT SPID INTO l_spid
Line 1338: FROM V$PROCESS
1334:
1335: BEGIN
1336:
1337: SELECT SPID INTO l_spid 1338: FROM V$PROCESS 1339: WHERE ADDR = (
1340: SELECT PADDR
1341: FROM V$SESSION
1342: WHERE AUDSID = USERENV('SESSIONID') );