FTP Command From JSP Fails on 11.2.0.2 (Doc ID 1311285.1)

Last updated on JULY 05, 2017

Applies to:

Oracle Server - Enterprise Edition - Version 11.2.0.2 and later
Information in this document applies to any platform.

Symptoms


A java stored procedure that sends data via ftp using a java stored procedure fails on an 11.2.0.2 DB with the following error reported:

*ERROR* java.net.SocketTimeoutException: timeout failure in poll code

Example of failing code:


SQL> DECLARE
2
3 -- c_intdir VARCHAR2(100) := apps.FND_PROFILE.VALUE('UINTDIR');
4
5 pi_conbil_host VARCHAR2(20);
6 v_file_name VARCHAR2(100);
7 v_conbil_file VARCHAR2(100);
8 v_password VARCHAR2(100);
9
10 v_result VARCHAR2(240); -- Result of copying a file
11
12 BEGIN
13
14 pi_conbil_host := 'ftp.oracle.com'; -- Change the destination host name
15 v_file_name := 'abc.txt'; -- Change the source file name
16 v_conbil_file := '/support/incoming/unisys/abcx98.txt'; -- Change the desti
nation file name
17 v_password := 'ftp'; -- Change the password for destination host sign-on
18
19 v_result := ustdfnd_ftp ('PUT',
20 pi_conbil_host,
21 'E:\lial\Joe_test.dat',
22 v_conbil_file,
23 'anonymous', -- Change the usercode for destination host sign-on
24 v_password,
25 'ascii');
26
27 DBMS_OUTPUT.PUT_LINE('Result -- ' || v_result);
28
29 END;
30 /
Result -- *ERROR* java.net.SocketTimeoutException: timeout failure in poll code

Changes

Upgraded to 11.2.0.2.
Using Windows 2003 as FTP Server.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms