drop user [message #1012] |
Wed, 20 March 2002 22:33 |
Michel
Messages: 6 Registered: November 2001
|
Junior Member |
|
|
Is it possible to drop a user in a after-row-delete trigger? If not is there any other way???
I get the error message that a COMMIT cannot be performed in a trigger.
Problem description:
If I delete a person from the persons table then I want to drop the user that is equal to the column USERNAME.
|
|
|
Re: drop user [message #1013 is a reply to message #1012] |
Wed, 20 March 2002 23:23 |
seng
Messages: 191 Registered: February 2002
|
Senior Member |
|
|
Using dynamic SQl (DBMS_SQL package). with this dynamic package, you can call DML and DDL in procedure/trigger. Hope this is helping.
|
|
|