|Unable to Download file from DB application [message #607320]
||Tue, 04 February 2014 21:27
Registered: August 2013
I'm very new to Application Express.
As part of learning, I created a databse application for uploading/downloading files from it.
One of the column (BLOB type) in my table is storing the files.
Table Column Data Type Length Precision Scale Primary Key Nullable Default Comment
KT_FILE_SUBJECT NAME VARCHAR2 4000 - - 1 - - -
SUBJECT VARCHAR2 4000 - - - - -
ID NUMBER 22 - - - - -
BLOB_CONTENT BLOB 4000 - - - - -
MIME_TYPE VARCHAR2 4000 - - - - -
I'm using below query as display columns on app page.
select substr(name, instr(name, '/', 1, 1)+1) "File Name", subject from kt_file_subject
File Name SUBJECT
SQL_Queries.pdf SQL Queries for Practice
Knowledge_Refreshment_On_Clearcase.doc Clearcase - Knowledge Refreshment Doc
I actually made the "File Name" as URL type to download file when anyone click on it.
But it is throughing below error while clicking on link.
500 - Internal Server Error
Is it not referring the stored file to download?
Could anyone help me with the mistakes what I've done here please?
If possible, kindly provide some simple guide for DB app development...
Thanks in advance.