Error: SyntaxError: Unexpected token P in JSON at position 0

Question

hello team,

 

i am using the following code and i am getting the error mentioned in the subject line.

 

code:

 

Declare

v_mime VARCHAR2(255);

v_length NUMBER;

v_file_name VARCHAR2(350);

Lob_loc BLOB;

BEGIN

SELECT MIME_TYPE, BLOB_CONTENT,filename,DBMS_LOB.GETLENGTH(blob_content)

INTO v_mime,lob_loc,v_file_name,v_length

FROM my_files;

-- WHERE id = p_file;

--

-- set up HTTP header

--

-- use an NVL around the mime type and

-- if it is a null set it to application/octect

-- application/octect may launch a download window from windows

owa_util.mime_header( nvl(v_mime,'application/octet'), FALSE );

-- set the size so the browser knows how much to download

htp.p('Content-length: ' || v_length);

-- the filename will be used by the browser if the users does a save as

--htp.p('Content-Disposition: attachment; filename="'|| replace(replace(substr(v_file_name,instr(v_file_name,'/')+1),chr(10),null),chr(13),null)|| '"');

htp.p('Content-Disposition: attachment; filename="' || v_file_name || '"');

-- close the headers

owa_util.http_header_close;

-- download the BLOB

wpg_docload.download_file( Lob_loc );

end;