RE: A Select Statement

From: Sandeep Kurliye <Sandeep.Kurliye_at_almarai.com>
Date: Mon, 3 Jul 2000 11:34:41 +0300
Message-Id: <10547.111090@fatcity.com>

Prem,

Can you tell more about oracle errors which you are getting in alert log.....

I was having similar kind of problem on oracle 7.3.4 and that has been solved.

Sandeep.

Riyadh, Saudi Arabia.

	-----Original Message-----
	From:	prem_at_ibsplc.com [SMTP:prem_at_ibsplc.com]
	Sent:	Monday, July 03, 2000 2:46 PM
	To:	Multiple recipients of list ORACLE-L
	Subject:	A Select Statement

	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).

Received on Mon Jul 03 2000 - 03:34:41 CDT