running Built-in HOST in Oracle Forms

[titouss]

I need to run perl file from oracle forms, to retrieve data from text files using Perl, insert that data into the oracle tables, and return to the Oracle.

All steps except first one I can do.
I can use command “perl overwrite.pl” from command line (Start --> Run
--> perl overwrite.pl) the same way as in the DOS prompt. The program in the file overwrite.pl will be run and give me expected result.

But I cannot run the same command (“perl overwrite.pl”) from SQL*PLUS using
Built-in Host: HOST(‘perl ‘||’overwrite.pl’); or HOST('perl overwrite.pl');. In both cases I can see like DOS prompt appears for a moment, but there is no expected result from the running program.

Thank you,
Stanley

 

[lewisp]

Check the contents of the DOS PATH variable. You may need to specify the exact path to perl in your host command. eg.

HOTS('c:\progs\perl\perl etc');