Hi

I have the following delete trigger

CREATE OR REPLACE TRIGGER db_admin_delete
BEFORE DELETE ON ADMININFO
FOR EACH ROW
DECLARE
pragma AUTONOMOUS_TRANSACTION;
BEGIN
execute immediate 'drop user ' || ld.username || ' cascade';
END;
/

I have similar triggers for add and update, they work fine. But the above delete trigger gives the following exception:

ERROR at line 1:
ORA-01403: no data found

Can anyone please help me out here

Thanks
Neelima