736: sid NUMBER;
737: BEGIN
738: SELECT s.sid
739: INTO sid
740: FROM v$session s, v$process p
741: WHERE s.paddr = p.addr
742: AND audsid = USERENV('SESSIONID');
743:
744: RETURN sid;
748: sid NUMBER;
749: BEGIN
750: SELECT s.serial#
751: INTO sid
752: FROM v$session s, v$process p
753: WHERE s.paddr = p.addr
754: AND audsid = USERENV('SESSIONID');
755:
756: RETURN sid;