Line 316: CURSOR get_dbname IS SELECT name FROM v$database;
312: FROM v$session a, v$process b
313: WHERE audsid = userenv('SESSIONID')
314: AND a.paddr = b.addr;
315: 316: CURSOR get_dbname IS SELECT name FROM v$database; 317:
318: v_sid v$session.sid%type;
319: v_serial v$session.serial#%type;
320: v_spid v$process.spid%type;