Xref: alice comp.databases.oracle.server:79483
Path: alice!news-feed.fnsi.net!news.idt.net!newsfeed.mathworks.com!cyclone.swbell.net!nnrp3.rcsntx.swbell.net.POSTED!not-for-mail
From: "spencer" <spencerp@swbell.net>
Newsgroups: comp.databases.oracle.server
References: <946563069.23198.0.nnrp-14.9e984b29@news.demon.co.uk>
Subject: Re: 8.1.5 - Dual gone schizoid
Lines: 14
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2919.6600
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6600
Message-ID: <TJpb4.2153$e12.8065@nnrp3.rcsntx.swbell.net>
Date: Sat, 1 Jan 2000 10:14:31 -0600
X-Complaints-To: abuse@swbell.net
X-Trace: nnrp3.rcsntx.swbell.net 946743283 216.63.51.55 (Sat, 01 Jan 2000 10:14:43 CST)
NNTP-Posting-Date: Sat, 01 Jan 2000 10:14:43 CST
Organization: SBC Internet Services

Yes, it is possible to have more than one row in SYS.DUAL.  We
had it happen in Oracle 7.3.2 on HP-UX 10.20, and we had the
same error in our application (fetch returns more than one row),
so we modified our application SQL to ensure that it returned
only one row:

select max(sysdate) into d from sys.dual ;

Our DBA was not able to track down what caused the second row to
be inserted into SYS.DUAL. He was, howeber, able to delete the
offending row.  But now, if this happens again, our application
will continue to work !