Re: calling a trigger...forms 5.0

Execute_Trigger( trigger_name VARCHAR2 ): Although you can use EXECUTE_TRIGGER to execute a built-in trigger as well as a user-named trigger, this usage is not recommended, because the default fail behavior follows a different rule than when invoked automatically by Form Builder as part of default processing. For example, in default processing, if the When-Validate-Item trigger fails, it raises an exception and stops the processing of the form. However, if the When-Validate-Item trigger fails when it is invoked by EXECUTE_TRIGGER, that failure does not stop the processing of the form, but only sets Form_Failure to FALSE on return from the EXECUTE_TRIGGER built-in.

mdesouza_at_YAHOO.COM wrote in article <772kr7$umv$1_at_nnrp1.dejanews.com>...
> Hi all
>
> Is there a way I can call a trigger within a procedure
>
> ie call('ON-ERROR')
>
Received on Mon Jan 11 1999 - 15:56:49 CET