Send a job from pc Oracle forms 5.0 to UNIX server for execution

Hi -

We are about to start converting our SQL*Forms 3.0 forms on SUN UNIX to Developer/2000 release 2.1, Oracle forms 5.0. The forms will be developed on win95/NT and will be run from win95 pc clients.

Our main database instance is RDBMS 7.3.3 and majority of our other scripts/programs are on Sun Solaris 2.5.1 UNIX server.

In SQL*Forms 3.0 which are currently 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 / @$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.

I feel it is possible to send a job request to UNIX server from a PC 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 PC 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 Wed Mar 24 1999 - 15:55:52 CST