| File Transfer forbidden [message #347238] |
Thu, 11 September 2008 02:58  |
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 #347245 is a reply to message #347242] |
Thu, 11 September 2008 03:11  |
|
|
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 |
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 |
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
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
