Re: Help needed: Simple Forms V3 Qns.

In <1993Jan12.083949.1_at_ocvaxc.cc.oberlin.edu> bamon_at_ocvaxc.cc.oberlin.edu writes:

>In article <1993Jan11.230248.8262_at_brt.deakin.edu.au>, ajmex_at_brt.deakin.edu.au writes:
> DEFINE TRIGGER
 
> NAME = POST-COMMIT
> TRIGGER_TYPE = V3
> DESCRIPTION = Post Commit
> TEXT = <<<
> declare
> temp_command char(200);
> begin
> /* batch the program */
> select
> 'batch/log=fa_log:fasj0630_BATCH.log' ||
> '/noprint/keep/noidentify/noconfirm fasj0630' ||
> '/param=("FASF0340","' ||
> :form_variables.test_only_flag ||
> '")'
> into temp_command from dual;

There is no need use a select statement to accomplish this. PL/SQL allows you to simply

temp_command := 'batch/log=fa_log:fasj0630_BATCH.log' ||
                '/noprint/keep/noidentify/noconfirm fasj0630' ||
                '/param=("FASF0340","' ||
                :form_variables.test_only_flag ||
                '")';



>        host(temp_command,NO_SCREEN);

>        message('Batched program FASJ0630.');

>      end;

>      >>>

> ENDDEFINE TRIGGER
Received on Tue Jan 12 1993 - 18:54:08 CET