Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Bug or Misunderstanding ? Delete...Returning into does not work as I expected
<snip>
>
> I agree, both are perfectly legimitate.
>
> However,
>
> Select salary from emp where 0=1;
>
> is also perfectly legimitate, yet it throws a 'no data found'
> exception at runtime if you add the 'into':
>
> Select salary into sal from emp where 0=1;
>
> I would have thought that a 'returning...into' would behave the same
> as 'select...into' does. It may be normal, but it doesn't seem
> particularly intuitive or consistent.
>
then an update returning of say 3 rows. should raise to_many_rows ?
Received on Tue Feb 04 2003 - 16:37:54 CST