-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|