Welcome Guest ( Log In | Register )


 
 
 
 
 
 

 
 
Oracle 

Performance Tuning Reference poster
 
Oracle training in Linux 

commands
 
Oracle training Weblogic Book
 
Easy Oracle Jumpstart
 
Oracle training & performance tuning books
 
Burleson Consulting Remote DB Administration
 
 
 
Closed TopicStart new topic
> Help required to transfer output file from one server to another server using Stored procedure
Debo1345
post Apr 9 2012, 01:35 PM
Post #1


Newbie
*

Group: Members
Posts: 2
Joined: 23-March 12
Member No.: 46,971



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)
Attached File  Procedure.txt ( 3.28K ) Number of downloads: 4
 
Go to the top of the page
 
+Quote Post
HAL9000
post Apr 9 2012, 05:47 PM
Post #2


Advanced Member
***

Group: Members
Posts: 880
Joined: 25-September 07
Member No.: 12,336



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.
Go to the top of the page
 
+Quote Post
burleson
post Apr 9 2012, 05:56 PM
Post #3


Advanced Member
***

Group: Members
Posts: 11,610
Joined: 26-January 04
Member No.: 13



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!


--------------------
Hope this helps. . .

Donald K. Burleson
Oracle Press author
Author of Oracle Tuning: The Definitive Reference
Go to the top of the page
 
+Quote Post

Closed TopicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

 

Lo-Fi Version Time is now: 21st October 2014 - 04:29 PM