Different behaviour of TOO_MANY_ROWS in 8i and 9i

Hi

Just by chance, i stumbled about the following: I executed the following block on two different Servers, one is v8.1.7.4.0, the other v9.2.0.4.0.

declare
  x number := NULL;
begin
  select w into x from (select 9 w from dual union all select 3 from dual) a;
exception
  when others then
    dbms_output.put_line('EXCEPTION: ' || x); end;

On 8i, the result is:

EXCEPTION: as expected (well, by me...)

On 9i, it's:

EXCEPTION: 9 Looks like 9i fetches the first record and then raises TOO_MANY_ROWS, while 8i fetches nothing at all.

Can someone give me some insights on this one?

cu
Holger Received on Thu Jan 13 2005 - 10:17:55 CST