RE: e: when is an error msg not an error msg ?

Paul,

I've seen something similar under windows when somebody incorrectly defined an oracle_home environment variable.

Might this be happening in you case?

HTH,
Bruce Reardon

-----Original Message-----
Sent: Thursday, 14 November 2002 9:59 AM

"Sherman, Paul R." wrote:
>
> Hello,
>
> I've looked over hill and over dale at many web-sites (MetaLink, google,
> asktom, etc.), to no avail, so could someone on the list bail me out on this
> question - what causes the following error message:
>
> ORACLE ERROR=>Error while trying to retrieve text
> for error ORA-03114
>
> Now, I know what causes the 03114; I need to know why I am getting the
> 'error while trying to retrieve... I get this error on my test and
> production servers, but not the development server. All have the same # of
> files in $ORACLE_HOME/rdbms/mesg. All are Oracle 8.1.7.4. Some file missing
> somewhere that I know not of ? Any help would be greatly appreciated.
>
> Thank you,
>
> Paul Sherman
> DBA Elcom, Inc.
> voice - 781-501-4143 (direct #)
> fax - 781-278-8341 (secure)
> email - psherman_at_elcom.com

Paul,

   Could there be any difference in the environment ? I am thinking about something such as

          env | grep -i lang
  Less likely to occur in the US than elsewhere, but ...   Also, in which context are you getting this? Do you get it in an anonymous PL/SQL package, say

  set serveroutput on
  begin
    dbms_output.put_line(sqlerrm(-3114));   end;
  /

  ?

-- 
Regards,

Stephane Faroult
Oriole Software
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Reardon, Bruce (CALBBAY)
  INET: Bruce.Reardon_at_comalco.riotinto.com.au

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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).