Re: A Select Statement

Prem,

The actual error number (ORA-, PLS-, etc...) is preferable to the text of the message, but in any event I have a hard time believing this error on a particular query is crashing the database. There are many reasons for this error, but it can occur on queries with implicit date conversions when the nls_date_format is changed.

You mention that the alert.log is filling with errors.  Is it this error message? If there are errors in the alert.log, do they reference a trace file? Are there any errors in the other background trace files (pmon,smon, etc...)? Are any trace files getting generated in udump or cdump?

HTH,

• Anita
  • prem_at_ibsplc.com wrote:
    > The error message is Non numeric character was found
    > where expected
    > This is an application running in Oracle 8.0.4.0 in
    > Unix environment
    >
    >
    >
    >
    >
    >
    >
    > "A. Bardeen" <abardeen1_at_yahoo.com> on 07/03/2000
    > 02:46:38 PM
    >
    > To: ORACLE-L_at_fatcity.com, PremChandran N/IBS
    > cc:
    > Subject: Re: A Select Statement
    >
    >
    >
    >
    > Prem,
    > A little more information would be helpful:
    > What are the error messages?
    > What are the db and OS versions?
    > Does an error get returned after the query or the
    > errors only in the alert.log?
    > -- Anita
    > --- prem_at_ibsplc.com wrote:
    > > Hi All,
    > > Can anybody please explain why this is
    > > happening.
    > >
    > > I have scheduled some jobs, and there is a select
    > > statement like this
    > >
    > >
    > > Select (next_date,'DD-MM-YYYY') where jonb =
    > 1000;
    > >
    > > This is causing some error and the alert file gets
    > > filled when the process
    > > executes and Oracle crashes.
    > >
    > > If anybody can give some explanation as to why
    > this
    > > happens, it would be of
    > > great help
    > >
    > >
    > > Thanks in Advance
    > >
    > > Prem
    > >
    > >
    > > --
    > > Author:
    > > INET: prem_at_ibsplc.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).
    >
    > __________________________________________________
    > Do You Yahoo!?
    > Kick off your party with Yahoo! Invites.
    > http://invites.yahoo.com/
    >
    >
    >
    >
    

    ---