Starting a job from NT 4.0 Form 5.0 on to another UNIX database server

[Quoted] We are about to start converting our SQL*Forms 3.0 forms on SUN UNIX to Developer/2000, Oracle forms 5.0.

Our main database instance is on UNIX server.

In SQL*Forms which are on UNIX server we start many of our SQL*Plus scripts, Fortran programs, Bourne shells etc. by using the HOST command such as:

   DEFINE TRIGGER  

      NAME = key-print
      TRIGGER_TYPE = V3
      DESCRIPTION = PRINT HISTORY REPORT
      TEXT = <<<
      if :stationbus.meter_id is not null then
         message('Analysis History Report for Station
'||:stationbus.station ||
                 ' is being sent to your printer.'); bell; pause;
         :global.var := 'nohup sqlplus -s / _at_$ORF_EXE/anahist '||
                         to_char(:stationbus.meter_id) || ' ' ||
                         to_char(:b1.ndb_sample);
         host (:global.var ||' > /dev/null &', no_screen);
      else
         message('Please Query the Station prior to requesting the
Report.');
         bell;
      end if;


      >>>

 

   ENDDEFINE TRIGGER or

host ('$ORF_SRC/run_report.sh '||:BAT.BAT||' &');

etc.

[Quoted] I feel it is possible to send a job request to UNIX server from NT via Oracle form 5.0.

Which is the best and easiest way ?

        dbms_pipe/dbms_alert

        dbms_job sent to the server for execution on the server

        rsh from NT form 5.0 to UNIX ( Is it possible? )         

        FTP a shell script to the server and have a daemon/cron look for it and run it ?

Any other ideas? details? examples? suggestions? all are welcome.

Thank you.

Suresh                    Received on Thu Mar 18 1999 - 17:36:21 CET