Home » Developer & Programmer » Forms » file transfer through pl/sql programming (10g)
file transfer through pl/sql programming [message #511875] Wed, 15 June 2011 12:42 Go to next message
ashish_sun123
Messages: 52
Registered: November 2010
Location: Bangalore
Member
Hi,


I am facing a issue with one of my programming application. We need to transfer a file through pl/sql programming from a unix server to another destination(target) server.

How can we do it through pl/sql programming. I learnt that oracle streams can be used for this.

I do not know what all code is required for this.

Please give some eg and send me the code for a sample text file.

I also want to encrypt with a password and zip the file

Thanks
Ashish

Report message to a moderator

Re: file transfer through pl/sql programming [message #511896 is a reply to message #511875] Wed, 15 June 2011 17:23 Go to previous messageGo to next message
John Watson
Messages: 8944
Registered: January 2010
Location: Global Village
Senior Member
The package dbms_file_transfer is probably what you need.

Report message to a moderator

Re: file transfer through pl/sql programming [message #511940 is a reply to message #511896] Thu, 16 June 2011 03:57 Go to previous messageGo to next message
ashish_sun123
Messages: 52
Registered: November 2010
Location: Bangalore
Member
what about zipping and password encryption

Report message to a moderator

Re: file transfer through pl/sql programming [message #511972 is a reply to message #511940] Thu, 16 June 2011 06:09 Go to previous message
John Watson
Messages: 8944
Registered: January 2010
Location: Global Village
Senior Member
What about saying "thank you"?

Report message to a moderator

Previous Topic: Repeat same record
Next Topic: Can't able to adjust the output of the form
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Sep 07 16:02:37 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.