[EMAIL PROTECTED] 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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
