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
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') );