Re: 8.1.5 - Dual gone schizoid

From: fumi <fumi_at_tpts5.seed.net.tw>
Date: 31 Dec 1999 19:16:43 GMT
Message-ID: <84iver$l90$1@news.seed.net.tw>

Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk> wrote in message news:946563069.23198.0.nnrp-14.9e984b29_at_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

It's probable that your sys.dual contains two rows: one is 'X', the other is null. Received on Fri Dec 31 1999 - 13:16:43 CST