PL/SQL (MOSC)

MOSC Banner

PL/SQL procedure for download files with resumes broken downloads support.

edited Apr 13, 2010 9:19PM in PL/SQL (MOSC) 1 commentAnswered
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);

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center