465: */
466:
467: FUNCTION get_session_process_id RETURN VARCHAR2 IS
468:
469: l_spid V$PROCESS.spid%TYPE;
470:
471: BEGIN
472:
473: SELECT SPID INTO l_spid
470:
471: BEGIN
472:
473: SELECT SPID INTO l_spid
474: FROM V$PROCESS
475: WHERE ADDR = (
476: SELECT PADDR
477: FROM V$SESSION
478: WHERE AUDSID = USERENV('SESSIONID') );