Re: 8.1.5 - Dual gone schizoid

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Thu, 30 Dec 1999 18:26:45 +0800
Message-ID: <386B3365.7587@yahoo.com>

Jonathan Lewis wrote:
>
> 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

Hello Johnathan

Is the "select sysdate" returning 1 row or 1 row + a null ?

Besides the obvious "Has anyone inserted another row?" question...

I'm running that exact configuration on my PC but there's only 1 row in my dual - I've created it at various time with both the "super-duper database assistant" and explict DDL and never had the problem...

Does this problem manifest itself at install time or 'later'...

Regards
Connor

--

---

Connor McDonald
"These views mine, no-one elses etc etc" connor_mcdonald_at_yahoo.com

"Some days you're the pigeon, and some days you're the statue." Received on Thu Dec 30 1999 - 04:26:45 CST