Home » Developer & Programmer » Forms » File Transfer forbidden (10g Application Server win xp)
File Transfer forbidden [message #347238] Thu, 11 September 2008 02:58 Go to next message
durgadas.menon
Messages: 365
Registered: December 2007
Location: Nowhere
Senior Member
Hi,

I am trying to use the webutil demo form but facing some problems with the download file option under the DOWNLOAD tab.

Here is the code of the procedure in the WHEN_BUTTON_PRESSED trigger on the DOWNLOAD from DB button ( screen shot attached)

PROCEDURE DOWNLOAD_DB IS
  l_success boolean;
BEGIN
  l_success := webutil_file_transfer.DB_To_Client_with_progress
                                    (clientFile      => :download.file_name
                                    ,tableName       => 'RESUMES'
                                    ,columnName      => 'RESUME'
                                    ,whereClause     => 'NAME = DURGADAS'
                                    ,progressTitle   => 'Download from Database in progress'
                                    ,progressSubTitle=> 'Please wait'
                                    );
  if l_success
  then
    message('File downloaded successfully from the Database');
  else
    message('File download from Database failed');
  end if;
  
  exception
  	when others
  	then
  	  message('File download failed: '||sqlerrm);

END;


Here is the table from which it is supposed to download


SQL> desc resumes
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------

 NAME                                               VARCHAR2(10)
 RESUME                                             BLOB


The code is not completing successfully and give the message
Quote:
'File download from Database failed'


when I read the Java console it gave this reading about

Quote:
2008-Sep-11 12:15:16.968 ERROR>WUT-121 [WEBUTIL_FILE_TRANSFER.DownloadInt] The file transfer has been forbidden by the Administrator


I had loaded the resume column with doc file (resume) and am trying to copy the contents back to a similar doc file on a different directory. What can be the reason for this? The user has read, write privilege on all the directories and has full access to WEBUTIL_DB package.

[EDITED by LF: removed center aligned code formatting]

[Updated on: Thu, 11 September 2008 11:58] by Moderator

Report message to a moderator

Re: File Transfer forbidden [message #347242 is a reply to message #347238] Thu, 11 September 2008 03:02 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Have you enabled file transfer to the database?

Gee, I just read the document this morning and I can't find it. Look in the webutil html page at http://www.oracle.com/technology/products/forms/htdocs/webutil/webutil.htm

David
Re: File Transfer forbidden [message #347245 is a reply to message #347242] Thu, 11 September 2008 03:11 Go to previous messageGo to next message
mudabbir
Messages: 235
Registered: April 2006
Location: Kuwait
Senior Member

Try this
Quote:
PROCEDURE DOWNLOAD_DB IS
l_success boolean;
BEGIN
l_success := webutil_file_transfer.DB_To_Client_with_progress
(clientFile => :download.file_name
,tableName => 'RESUMES'
,columnName => 'RESUME'
,whereClause => 'NAME ='||''''||'DURGADAS'||''''
,progressTitle => 'Download from Database in progress'
,progressSubTitle=> 'Please wait'
);
if l_success
then
message('File downloaded successfully from the Database');
else
message('File download from Database failed');
end if;

exception
when others
then
message('File download failed: '||sqlerrm);

END;
Re: File Transfer forbidden [message #347299 is a reply to message #347242] Thu, 11 September 2008 04:47 Go to previous messageGo to next message
durgadas.menon
Messages: 365
Registered: December 2007
Location: Nowhere
Senior Member
Quote:
Have you enabled file transfer to the database?


I wondering what this meant. Do you mean that have I loaded the file in the database? If this the question then Yes

If this is not what you meant then could you let me know what this means? are you referring to any parameter which I need to set.
Re: File Transfer forbidden [message #347393 is a reply to message #347238] Thu, 11 September 2008 08:22 Go to previous messageGo to next message
Kaeluan
Messages: 179
Registered: May 2005
Location: Montreal, Quebec
Senior Member
search in your %ORA_HOME%/forms/server for file webutil.cfg.
In the file search for line "transfer.database.enabled". By default this property is set to false for security measure. Just set it to true

Hope it help
Re: File Transfer forbidden [message #347515 is a reply to message #347393] Fri, 12 September 2008 00:12 Go to previous message
durgadas.menon
Messages: 365
Registered: December 2007
Location: Nowhere
Senior Member
Thanks a lot Kaeluan and Mudabbir..atlast I am able to load and download files from the database... Smile Surprised
Previous Topic: delete and combobox in oracle datagrid? beginner pls help
Next Topic: Installation errors: Developer 2000 & Oracle on one machine (probably)
Goto Forum:
  


Current Time: Sun Dec 04 19:09:52 CST 2016

Total time taken to generate the page: 0.26392 seconds