Re: calling UNIX programs from Forms 4.5

Ron,

An efficient and secure way is through Oracle DBMS Pipes. It's a simple message queue that informs a waiting program that client work awaits. The best part this that notification is immediate, and no resources are used in "checking" for work.

Our company is looking for BETA customers this Spring who are willing to trial our product, SQL*Pipeline. It allows simple remote execution of shell scripts or host programs via stored procedures (passing parameters and returning exit codes and data). You can even use the native dbms_jobs package to schedule jobs.

If you are interested, please check our Web Site at http://www.dps-corp.com/prod.htm or contact us by phone or e-mail. Our number is 410-321-8444. Ask for Paul Tuma or myself.

We currently support AIX and HP-UX (while always looking for other platforms).

Regards,

Eric Keen
Director Product Development
DPSC
Towson, MD 21286

Ohio Valley Laboratory wrote:
>
> Does anyone know of a good way to call UNIX programs (ctl, C, PL-SQL,
> etc...) from inside a Forms 4.5 module. We are currently using forms
> 3.0 which is UNIX based and just do a host call to these programs.
> Forms 4.5, being PC based has no connections to UNIX (that I know of) to
> do anything like this.
>
> The only solution we can come up with is to create a table and insert
> the program name and parameters into it. Then on the UNIX side, have a
> cron constantly check for records in that table, extract the record, and
> run it.
>
> Is there a simpler way?
>
> Thanks,
> Ron Watson
 

-- 
Only 685 days left to stock up on canned goods, fuel & ammo before
2000/1/1