7:24-sherlock:ts01:jkstill-0 > oerr ora 1422
01422, 0, "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
07:25:43 sherlock - [EMAIL PROTECTED]
What does the load procedure look like?
AFAIK this means that a select into returns more than one row in the
subquery, which would indicate use of PL/SQL
Any triggers etc..??
Jack
-Original Message-
Sent: Friday, August 22, 2003 4:45 PM
To: Multiple recipients of list ORACLE-L
Hal
Title: RE: Exact fetch
it means "Exact fetch returns more than requested number of rows", nothing more, nothing less.
HTH
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this