Ftping using oracle procedure [message #396765] |
Wed, 08 April 2009 00:27 |
ashi1234
Messages: 3 Registered: April 2009
|
Junior Member |
|
|
Hi
I am executing a shell script from oracle plsql by executecmd. This shell contains the ftp scripts. when i am executing from server, I am getting ftp failed message but when i am running from client using sqlplus, i am able to ftped successfully. Can someone help me.
|
|
|
|
Re: Ftping using oracle procedure [message #396875 is a reply to message #396766] |
Wed, 08 April 2009 04:40 |
ashi1234
Messages: 3 Registered: April 2009
|
Junior Member |
|
|
Hi BlackSwan,
Thanks for you reply.
The shell script is being called from below procedure:
mppspp1.Oscmd(K_FTP_COMMAND || ' ' || K_FILE_NAME );
where K_FTP_COMMAND='/sites/vsna/site/live/ftp/scripts/./transfer_edw_file.ksh'
and K_FILE_NAME='VSNAEDWSAL'.
errors:
02:00:50 INFO IT58817-P00021: 250 SenderId: "VSNAP" ReceiverId: "IG3" FileName: "VSNAEDWSAL" RefNo: "TCPIP" STRIPLF
02:00:50 INFO IT58817-P00021: waitForRequest...
02:00:50 ERROR IT58817-P00021: FTPServer: IOException, Client Connection closed.
The shell scripts is attached here.
When i am running this from cron, i am getting above error, but when i am running from SQLplus, the file is getting transfered to destination server.
Please let me know if you need more information.
[Updated on: Wed, 08 April 2009 04:43] Report message to a moderator
|
|
|
|
|
|
Re: Ftping using oracle procedure [message #397052 is a reply to message #396765] |
Wed, 08 April 2009 13:41 |
|
BlackSwan
Messages: 26766 Registered: January 2009 Location: SoCal
|
Senior Member |
|
|
>When i am running this from cron
I suspect the problem is due to incorrect or missing environmental variable.
At the top of the script add the following line:
env | sort -o /tmp/ftp.env
Then compare your interactive (working) environment to cron's (which fails).
make the one which fails as close as possible to one that works.
|
|
|