SQL & PL/SQL

Hi All,

Need some help on the Returning Clause. I ve given the example below,

update abc set abc.item_id='1315' where abc.item_id='1400'
returning abc.distribution_centre into :testvar;

Do note that there are two item_ids which satisfy the condition above.

When I try executing this, I was expecting an error saying the query returns more than one row. However, i get the following message,

ORA-24369: required callbacks not registered for one or more bind handles.

I have two qustions in relation to this,
1. How do I execute this query without getting an error?
2. How do I retrieve more than one value using the 'Returning' clause.

Any help will be appreciated.

Thanks.