Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Unexpected ORA-01422: exact fetch returns more than requested number of rows
The problem was use of ALL_TAB_COLUMNS rather than USER_TAB_COLUMNS.
The customer in question had multiple schemas containing the
table/column. It was working elsewhere because the other sites only
had one schema with the table/column.
Received on Wed Sep 27 2006 - 00:21:43 CDT