Re: 8.1.5 - Dual gone schizoid

From: Pete Sharman <psharman_at_us.oracle.com>
Date: Thu, 30 Dec 1999 11:02:55 -0800
Message-ID: <386BAC5F.34FE4F4@us.oracle.com>

Had exactly this problem when I worked as a client rather than with Oracle. We allowed a manager who said he still had DBA skills to reorganize a database. Big mistake - next morning all our forms returned the 1422 error because they had a date-time field that was populated by a select from dual, and the manager had somehow ended up with two rows in DUAL. We didn't allow him to do maintenance by himself again.

We never let him forget it either!

Pete

Connor McDonald wrote:

> 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 - 13:02:55 CST