Re: userenv error

lhoska_at_calibresys.com wrote:
>
> Hi,
> Some one (probably developers) dropped number of our application specific
> tables used for user's application log on.
> Not nice of them but at least they did it on their own test database. If
> they did it on production db it would be more stressful.
> At this point tables have been restored.
> Now when attempting to log on to the application user's get this error:
> ORA-02003: invalid USERENV parameter
> Cause: An invalid parameter was specified for the USERENV function.
> Action: Specify one of the allowable parameters TERMINAL, SESSIONID,
> ENTRYID, or NLS_LANG.
> Please bring some light to my problem.
> Thank you very much.
>

May be stupid but ... Are you sure that you are not applying Oracle8 code to an Oracle7 database? The only case when I have seen this message was when trying userenv('INSTANCEID') against an Oracle7 database.

-- 
Regards,

Stephane Faroult
Oriole Corporation
Voice:  +44  (0) 7050-696-269 
Fax:    +44  (0) 7050-696-449 
Performance Tools & Free Scripts
--------------------------------------------------------------
http://www.oriole.com, designed by Oracle DBAs for Oracle DBAs
--------------------------------------------------------------
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Stephane Faroult
  INET: sfaroult_at_oriole.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).