| Not to clear the record after delete [message #414374] |
Tue, 21 July 2009 21:14  |
ap_karthi
Messages: 87
Registered: October 2007
Location: Bangalore
|
Member |
|
|
Hello,
Employee table consists of employee number and name columns.
Select, insert and update grant is given for this table. No delete grant. (Backend level).
When I try to delete the employee "GGGG", it pops up the message as shown (refer attachment), because a code is written in ON-ERROR trigger
DECLARE
err_code NUMBER := ERROR_CODE;
err_txt VARCHAR(110);
BEGIN
IF err_code = 40510 THEN
err_txt := 'You don''t have the privilege to delete this record.';
Message(err_txt);
Message(err_txt);
END IF;
END;
The record is cleared; you can see the employee "GGGG" is not shown (refer attachment), but when I query again it shows the employee "GGGG".
My Query:
The record should not to clear; the cursor should go back the employee "GGGG", after populating the message. How to do it?
Thanks.
-Karthik
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
