Home » Developer & Programmer » Application Express, ORDS & MOD_PLSQL » Unable to Download file from DB application (APEX 4.2)
Unable to Download file from DB application [message #607320] Tue, 04 February 2014 21:27
hi.villinda
Messages: 4
Registered: August 2013
Location: Singapore
Junior Member
Hello all,

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.

describe kt_file_subject;

Quote:
OUTPUT
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 


Quote:
OUTPUT
File Name SUBJECT
SQL_Queries.pdf SQL Queries for Practice
303128_2191426219540_538080831_n.jpg Admin
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.
Quote:
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.
Regards,
VRN
Previous Topic: Call to owa_util Packages
Next Topic: Invoke external stored procedure from apex
Goto Forum:
  


Current Time: Thu Mar 28 14:22:28 CDT 2024