Bug or Misunderstanding ? Delete...Returning into does not work as I expected

From: FC <flavio_at_tin.it>
Date: Tue, 04 Feb 2003 18:26:42 GMT
Message-ID: <CBT%9.180453$AA2.7097288@news2.tin.it>

Hello folks,
I just ask you whether I misunderstood the documentation or it's a PL/SQL bug.
Facts:

   Oracle 8.1.7.0.0 EE, Windows 2000 Pro.

...

Delete from configurations

 where cfg = num_cfg                                            -- this is a

PK on table
returning cfg_dsc into var_cfg_description;
...

Now, I would expect an exception like NO_DATA_FOUND to be raised if num_cfg does not match any existing record, because the returning clause cannot return any value, but this doesn't happen.

Of course there are simple workarounds if one needs to raise an error but I didn't find any comment about this behaviour in the PLSQL user's guide and reference, is this normal?

Bye,
Flavio Received on Tue Feb 04 2003 - 12:26:42 CST