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

 

[MikeLacey]

try specifying the full path to your perl script Stan Mike
michael.j.lacey@ntlworld.com
Email welcome if you're in a hurry or something -- but post in tek-tips as well please, and I will post my reply here as well.