Help required to transfer output file from one server to another server using Stored procedure Options

[Debo1345]

Hi,
We are running a store procedure by calling it from shell script.The shell script is running in Server1 and the stored procedure is running in server2(which is the data base server.).

Functionality of the stored procedure:Generating a tab delimited file and place in a directory.

Requirement:
The requirement is that the store should be modified in such a way that it should drop the output file to Server1 itself(The server from where it is getting called).

Attaching the store procedure for reference.
In the store procedure,we have a variable "lv_file_dir" which currently refers to the directory location in Databse server(Server 2) We have to change this SP such that it drops the generated file in Server1 itself(From where the shell script is running).

Please helpppppppppppppppppppppppppppppppppppp!!!!!!!!!!:-(:-(

Thanks
Debs

Attached File(s)

 Procedure.txt ( 3.28K ) Number of downloads: 4

 

[HAL9000]

Debs,

You are in the wrong forum. This is a DBA forum, only for asking specific questions.

For Oracle support services, go to MOS http://support.oracle.com

or go to OTN:

https://forums.oracle.com/forums/forum.jspa?forumID=75

They will help you solve this.

Just tell them it's urgent.

[burleson]

Hi Debs,

>> The requirement is that the store should be modified in such a way that it should drop the output file to Server1 itself(The server from where it is getting called).


OK, no problem, Server 1 calls the extract on server 2 andf server 2 sends it back to server 1.

You have three options:

1 - Wait until the tab-delimited file is completed and have the script open-up a secure connection to transfer it back to server 1 (ftp, vpn, ssh).

2 - Open a connection back to server one, and write the records to a flat file on server 1, bypassing the write to server 1.

3 - Call BC support at 800-766-1884. We can get this done in just a few hours . . .

If you are not familiar with Oracle shell scripting, see here, especially the examples in the script download:

http://www.rampant-books.com/book_0701_shell_scripting.htm

This is about a 4-10 hour coding task, including testing time . . .


Good Luck!