Xref: alice comp.databases.oracle.server:79481
Path: alice!news-feed.fnsi.net!feed.newsfeeds.com!newsfeeds.com!cyclone.pbi.net!151.164.30.35!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: 44
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: <TCpb4.2149$e12.7968@nnrp3.rcsntx.swbell.net>
Date: Sat, 1 Jan 2000 10:07:02 -0600
X-Complaints-To: abuse@swbell.net
X-Trace: nnrp3.rcsntx.swbell.net 946742835 216.63.51.55 (Sat, 01 Jan 2000 10:07:15 CST)
NNTP-Posting-Date: Sat, 01 Jan 2000 10:07:15 CST
Organization: SBC Internet Services


"Jonathan Lewis" <jonathan@jlcomp.demon.co.uk> wrote in message
news:946563069.23198.0.nnrp-14.9e984b29@news.demon.co.uk...
>
> Has anyone encountered this before ?
> Oracle 8.1.5.0 on NT sp3:
>
> sqlplus sys/sys
> select count(*) from sys.dual;
>
>  COUNT(*)
> ---------
>        2
>
> select sysdate from sys.dual;
>
>  SYSDATE
>  -------
> 30-DEC-99
>
>
> declare
>     d date;
> begin
>     select sysdate into d from sys.dual;
> end;
> .
> /
>
> ORA-01422: exact fetch returns more than requested number of
rows
>
>
>
> --
>
> Jonathan Lewis
> Yet another Oracle-related web site:
http://www.jlcomp.demon.co.uk
>
>
>