populating table based on v$session

From: Jeffrey Beckstrom <JBECKSTROM_at_gcrta.org>
Date: Tue, 05 Dec 2006 10:59:04 -0500
Message-Id: <s575510d.048@groupwise.gcrta.org>

Here is my error any ideas why the error:  

doing session
old 38: , '&&lv_host_name', '&&lv_instance_name', SYSDATE new 38: , 'RTA14', 'or14', SYSDATE
from V$SESSION sess

                   *

ERROR at line 39:
ORA-02070: database EMGR does not support operator USERENV in this context    

The sql is:
prompt doing session
INSERT into rta.lms_V$SESSION_at_emgr
( SADDR
, SID
, PADDR
, USER#
, USERNAME
, COMMAND
, STATUS
, SERVER
, SCHEMANAME
, OSUSER
, PROCESS
, MACHINE
, TERMINAL
, PROGRAM
, TYPE
, LAST_CALL_ET
, LOGON_TIME
, machine_id , db_name , timestamp)

SELECT
  SADDR
, SID
, PADDR
, USER#
, USERNAME
, COMMAND
, sess.STATUS
, SERVER
, SCHEMANAME
, OSUSER
, PROCESS
, MACHINE
, TERMINAL
, PROGRAM
, TYPE
, LAST_CALL_ET
, LOGON_TIME
, '&&lv_host_name', '&&lv_instance_name', SYSDATE
from V$SESSION sess ;      

Jeffrey Beckstrom
Database Administrator
Greater Cleveland Regional Transit Authority 1240 W. 6th Street
Cleveland, Ohio 44113

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Dec 05 2006 - 09:59:04 CST