When performing a delete in pl sql it does not throw a when no_data_found when it
finds no records to delete. Is this correct?
Should we check for the item first and then do an if statement with a dbms_output.put_line
declare
begin
delete from demo_orders where order_id = 99;
exception
when no_data_found then
apex_application.g_print_success_message := '<p style="font-family:arial; font-size: 20px;
color: red;">Error: No records were found!</p>';
end;
Thanks
Howard