Home » Developer & Programmer » Forms » batch file and PKZIPC utility
batch file and PKZIPC utility [message #287839] Thu, 13 December 2007 14:18 Go to next message
fishkill777
Messages: 1
Registered: December 2007
Junior Member
I call a batch file from Oracle forms by clicking on a button. The batch file calls pkzipc utility
to extract the contents of a zip file, and place it in the destination xyzfolder. However, this is not
working.
The batch file and PKZIPC are located on the same server. When I run the batch file on the server,
pkzipc utility works fine. When I call the batch file from Oracle forms, then the utilty is not working.

When-button-pressed trigger has the following code:
declare
the_command varchar2(2000) := '\\ABCserver\ABCfolder\abcd.bat';
begin
host(the_command);
message('done');
end;

batch file code :
cd "\\ABCserver\c$\Program Files\PKWARE\PKZIPC"
pkzipc -extract -silent -nofix -overwrite -directories -logfile \\ABCserver\c$\xyzfolder\26.zip \\ABCserver\c$\sssfolder
exit

How do I resolve this ?
Thanks
SR
Re: batch file and PKZIPC utility [message #289129 is a reply to message #287839] Wed, 19 December 2007 18:40 Go to previous message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
What version of Forms are you running?

Have a look at http://www.orafaq.com/forum/m/282637/67467/?srch=client_host+cmd#msg_282637

David
Previous Topic: Error 305500 non-oracle exception with ole2 package and Outlook Application
Next Topic: Insert picture
Goto Forum:
  


Current Time: Fri Sep 27 08:22:53 CDT 2024