OraFAQ Forum: Forms » call batch file from Oracle Forms 10g

Home » Developer & Programmer » Forms » call batch file from Oracle Forms 10g

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

call batch file from Oracle Forms 10g [message #462607]

Fri, 25 June 2010 04:40

Shaheer
Messages: 50
Registered: June 2008
Location: Pakistan

Member

Hi,

I need Help. I want to call .bat file from oracle froms 10g.

I tried given below code but failed.

---------------------------------
declare

v1 varchar2(200);

begin

v1 := 'D:\Folder\Logicalbackup.bat';

HOST('cmd /c start'||v1,no_screen);

--HOST(v1);

end;
-----------------------------

The Logicalbackup.bat file contains:-

Cd d:\oracle\product\10.2.0\db_1\bin
d:
exp mw6/mw6@mw file=d:\mw6\backup\backupRGLHR.dmp log=d:\mw6\backup\backuplog\RGLHR.log

PLEASE HELP ME.... I WANT TO CALL .BAT FILE FROM ORACLE 10G FORMS.

Report message to a moderator

Re: call batch file from Oracle Forms 10g [message #462693 is a reply to message #462607]

Fri, 25 June 2010 12:45

Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Quote:

I tried given below code but failed.

What does "failed" mean? What happened?

Where is the .BAT file? Is it on a local computer, or on the server? Did you try CLIENT_HOST?

Report message to a moderator

Re: call batch file from Oracle Forms 10g [message #462715 is a reply to message #462693]

Sat, 26 June 2010 01:16

Shaheer
Messages: 50
Registered: June 2008
Location: Pakistan

Member

thanks for reply.

My OS is window XP and i am running my application through Oracle Forms & Report Services (Standalone).

.bat file is on local machine and .bat file not run through form. Please tell me how to use CLIENT_HOST in code.

Report message to a moderator

Re: call batch file from Oracle Forms 10g [message #462739 is a reply to message #462715]

Sat, 26 June 2010 05:57

Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

You still didn't explain what the failure is about.

Report message to a moderator

Re: call batch file from Oracle Forms 10g [message #465172 is a reply to message #462739]

Tue, 13 July 2010 01:46

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Sorry that I have been so long in replying. Have you solved your problem?

Look at 'webutil' for 'client_host'.

David

Report message to a moderator

Previous Topic:	Third level block handling in oracle forms 6i
Next Topic:	LOV filtering records (merged)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Sep 19 22:39:23 CDT 2024