PL/SQL procedure for download files with resumes broken downloads support.
I need to write PL/SQL procedure for download files with resumes broken downloads support.
But I have one problem.
I can't get http request RANGE value in my PL/SQL procedure.
This is my procedure:
procedure download_file(p_file_id in number) is
l_file_name docs.file_name%type;
l_mime_type docs.mime_type%type;
l_content docs.content%type;
l_file_size number(20);
-- for http request Range support
l_range varchar2(128 char);
l_range_start number(20);
l_amt number(4) := 4096;
l_raw raw(4096);
l_offset number(20);
0