home *** CD-ROM | disk | FTP | other *** search
/ NetNews Usenet Archive 1993 #1 / NN_1993_1.iso / spool / comp / database / oracle / 2778 < prev    next >
Encoding:
Text File  |  1993-01-12  |  1.7 KB  |  50 lines
  1. Newsgroups: comp.databases.oracle
  2. Path: sparky!uunet!spool.mu.edu!uwm.edu!zaphod.mps.ohio-state.edu!news.acns.nwu.edu!casbah.acns.nwu.edu!irving
  3. From: irving@casbah.acns.nwu.edu (Thomas Myers)
  4. Subject: Re: Help needed: Simple Forms V3 Qns.
  5. Message-ID: <1993Jan12.175408.22147@news.acns.nwu.edu>
  6. Sender: usenet@news.acns.nwu.edu (Usenet on news.acns)
  7. Nntp-Posting-Host: unseen1.acns.nwu.edu
  8. Organization: Northwestern University, Evanston, Illinois, USA
  9. References: <1993Jan11.230248.8262@brt.deakin.edu.au> <1993Jan12.083949.1@ocvaxc.cc.oberlin.edu>
  10. Date: Tue, 12 Jan 1993 17:54:08 GMT
  11. Lines: 37
  12.  
  13. In <1993Jan12.083949.1@ocvaxc.cc.oberlin.edu> bamon@ocvaxc.cc.oberlin.edu writes:
  14.  
  15. >In article <1993Jan11.230248.8262@brt.deakin.edu.au>, ajmex@brt.deakin.edu.au writes:
  16. >   DEFINE TRIGGER
  17.  
  18. >      NAME = POST-COMMIT
  19. >      TRIGGER_TYPE = V3
  20. >      DESCRIPTION = Post Commit
  21. >      TEXT = <<<
  22. >      declare
  23. >       temp_command char(200);
  24. >      begin
  25. >        /* batch the program */
  26. >        select
  27. >            'batch/log=fa_log:fasj0630_BATCH.log' ||
  28. >            '/noprint/keep/noidentify/noconfirm fasj0630' ||
  29. >            '/param=("FASF0340","' ||
  30. >            :form_variables.test_only_flag ||
  31. >            '")'
  32. >        into temp_command from dual;
  33.  
  34. There is no need use a select statement to accomplish this.  PL/SQL allows you
  35. to simply 
  36.  
  37. temp_command := 'batch/log=fa_log:fasj0630_BATCH.log' ||
  38.                 '/noprint/keep/noidentify/noconfirm fasj0630' ||
  39.                 '/param=("FASF0340","' ||
  40.                 :form_variables.test_only_flag ||
  41.                 '")';
  42.  
  43. >        host(temp_command,NO_SCREEN);
  44. >        message('Batched program FASJ0630.');
  45. >      end;
  46. >      >>>
  47.  
  48.  
  49. >   ENDDEFINE TRIGGER
  50.