Re: ORA-01422 error on each sql statement

From: IANAL_VISTA <IANAL_Vista_at_hotmail.com>
Date: Sat, 24 Sep 2005 01:20:25 GMT
Message-ID: <Xns96DABA941E1E9SunnySD@68.6.19.6>

"Miggins" <mtproc_at_yahoo.co.uk> wrote in news:1127491739.627758.154800_at_z14g2000cwz.googlegroups.com:

> Hi,
>
> Have a Forms 6i application with patch 13 running against a 9.2.0.1.0
> database stored on same machine in different home.
>
> However when i run the application any sql statement at all return
> ORA-01422. If I run the same statement as the same user from SQL*PLUS
> it works fine.
>
> If i run against an 8i database on another machine the same app works
> fine too.
>
> Any Ideas....this is quite urgent!!!!
>
>

oerr ora 1422
01422, 00000, "exact fetch returns more than requested number of rows" // *Cause: The number specified in exact fetch is less than the rows returned.
// *Action: Rewrite the query or change number of rows requested

Google is your friend if you take the effort to use it! Received on Fri Sep 23 2005 - 20:20:25 CDT