trigger failure

[Guest_imported]

why is this trigger not working?
when i execute this trigger, it gives an error that says:
identifier call_fin must be declared.
I know there is a field called call_now on the table tcall:
Please take a look:

create or replace trigger archive_call
after insert or update on tcall
FOR EACH ROW
BEGIN
IF (call_now = 'N' AND call_period = 'X') then
BEGIN
RAISE_APPLICATION_ERROR(-20001,'YOU MUST ENTER THE TYPE OF CALL');
DBMS_OUTPUT.PUT_LINE('YOU MUST ENTER THE TYPE OF CALL');
END;
call_period := call_period + 1;
END IF;
END;
tankem

 

[sem]

Your error can'not be produced by "executing" your trigger untill it contains some dynamic code, because this is compiler error rather then runtime. And I also can not find any references to call_fin.
Though your trigger probably contains errors because call_now and call_period variables are not declared.

 

[Guest_imported]

thanks sem!