Please help me with this interactive batch program

[Elomelo]

Dear Sir,
I have again and again tried to make this batch file. But every attempt ended in smoking! Please someone give me a solution.

I want to export oracle database dump file with some dos commands. Here I am describing the process step by step:

In command prompt window, I will write:
exp
In a couple of seconds the command prompt will return the reply:
Username:
I will write:
alpha
In a couple of seconds the command prompt will return the reply:
Password:
I will write:
alpha
In a couple of seconds the command prompt will return the reply:
Buffer Size:4906>
I will just press [ENTER]
.......... and so on..

How this program can be written could you please tell me? Every time after giving the input I must wait for the reply to provide next input.

Thanking in advance.

[foxidrive]

There is a command line for querying an sql database. See https://www.google.com.au/search?hl=en& ... l+database

Another tool you can script to control a gui is AutoIt

[aGerman]

I think that's what you're looking for: http://docs.oracle.com/cd/B10501_01/server.920/a96652/ch01.htm#1004778
As you can see you can write all in one command line or you could use a parameter file.

Regards
aGerman

[Elomelo]

There is a command line for querying an sql database. See https://www.google.com.au/search?hl=en& ... l+database

Another tool you can script to control a gui is AutoIt

Sorry sir, this search could not provide me with any solution. Thanks anyway.

[foxidrive]

Sorry sir, this search could not provide me with any solution. Thanks anyway.

I don't believe that there was no information about producing queries from the command line.

[Elomelo]

I think that's what you're looking for: http://docs.oracle.com/cd/B10501_01/server.920/a96652/ch01.htm#1004778
As you can see you can write all in one command line or you could use a parameter file.

Regards
aGerman

Dear aGerman,
I believe just a batch program will solve this problem which I myself cannot write.
Because I do not know how to wait for a response from DOS before giving the next input as "echo" in the command line, I do not know what I should write when I need to press just the ENTER key.

Could you please help me in this regard?
Thanks in advance.

[foxidrive]

I believe just a batch program will solve this problem which I myself cannot write.
Because I do not know how to wait for a response from DOS before giving the next input as "echo" in the command line, I do not know what I should write when I need to press just the ENTER key.

A batch file can help you use the command line version of a SQL query.

You are asking how to control a GUI program, and in most cases with modern programs that is not achievable with a batch file.
AutoIt is a scripting tool to control a GUI. SENDKEYS can control a GUI, but is not as reliable.

We don't have your program to test - and we don't even know its name.

[Elomelo]

Sorry sir, this search could not provide me with any solution. Thanks anyway.

I don't believe that there was no information about producing queries from the command line.

Sorry! Failure to understand the theme of your reply is my fault. Sorry again and thanks for your reply.