We have trigger set up for Delete statement before each row in <tablename>,
Before Each row trigger
begin
if :old:<column_name> = ' ' then
RAISE_APPLICATION_ERROR
(-20001,'Cannot delete <tablename> record with blank <column name> column');
end if;
end;
But, while deleting the records getting below errors, even when we add where condition in delete query as <column_name> <> ' ' (column not equal to blank)
Error information:
ORA-20001: Cannot delete <tablename> record with blank <column name> column
ORA-06512: at "<triggername>", line 3
ORA-04088: error during execution of trigger <trigger name>
Can you let me know how to resolve this trigger issue. Thanks in advance.