Home » SQL & PL/SQL » SQL & PL/SQL » PLS-00201 Error (Oracle 8i, Win XP)
PLS-00201 Error [message #348036] Mon, 15 September 2008 08:14 Go to next message
Derek N
Messages: 80
Registered: September 2002
Member
Hi

I created a trigger that retrieves terminal, nvl(program,module)and logon_time from v$session.

When I compile the trigger I get the following error:
PLS-00201: Identifier 'SYS.V_$SESSION' ,must be declared.

Can v$session be used in a trigger.

Regds
Re: PLS-00201 Error [message #348037 is a reply to message #348036] Mon, 15 September 2008 08:18 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
http://asktom.oracle.com/~tkyte/Misc/RolesAndProcedures.html

Regards
Michel
Re: PLS-00201 Error [message #348217 is a reply to message #348037] Tue, 16 September 2008 01:16 Go to previous message
Derek N
Messages: 80
Registered: September 2002
Member
Thanks Michel
Previous Topic: WITH Clause with Full Outer Join
Next Topic: Record Compatability
Goto Forum:
  


Current Time: Thu Dec 08 02:21:37 CST 2016

Total time taken to generate the page: 0.11087 seconds