Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Issue with BLOB download from classic report. APEX 23.2

isnotavailable29 hours ago — edited 28 hours ago

A classic report with a blob download. Was working under 5.1, I can't be sure anyone has used this since we upgraded to 23.2, but now some of the links work and some don't, instead I see the following in the "downloads" in chrome:

I tried re-creating the report region but it has the same issue.

Working link: https://example.com/ords/apex_util.get_blob?s=15746273382639&a=100&c=12100668214905604&p=513&k1=861&k2=&ck=485KiS17BI8HX3gbYGj8e3hDKP5lnZighgt9itOvv5u-Gpb8m62V4jWVMRv37keDN7KuckvNXX-KdEMF-1bAfg&rt=CR

Non-working link: https://example.com/ords/apex_util.get_blob?s=15746273382639&a=100&c=12100668214905604&p=513&k1=902&k2=&ck=h-3DqoT3LkoAo0eohB1wMlfn1R-8IAskom6wBC3OQ1-OR3ggjQQeGvXpJBp0MyRm0QT9JGr4LF8j0tEqBVcmMw&rt=CR

I can go into the database in SQLDeveloper, select the table with the BLOB, and download the file from the blob column without issue.

The files are all plain text .csv files

Query: select id, file_name, mime_type, length(blob_content) as length, created_on, created_by
from portal_landfill_file
order by created_on desc

Table has a single column primary key which is the selected 'ID' column.

Turning on debugging in APEX shows nothing, no debug log is created when you click one of the download links.
I've looked in the ORDs server logs but don't see an error related to this.
I asked our DBA and he doesn't see anything though I don't know what he's looking at.
It feels like the "check internet connection" appears immediately and no request is being made? – Not true, i see requests in the ORDs access log.
I don't see any JS errors on the page.

EDIT:

If I try this using Firefox i get the following error message:

And I see the requests in the ORDs request logs:

Failed:

1.2.3.4 - [21/Oct/2025:19:35:54 +0000] "GET /ords/apex_util.get_blob?s=16341982594912&a=100&c=12100668214905604&p=513&k1=921&k2=&ck=wqijKw5golLbi5DF6eu68bo5Gv8GT0V4PpRekxLc9I-P2ngAWQl7KB4-cxsCFfc1szHwmo7cWM8eLvv6PR-Ghg&rt=CR HTTP/2.0" 200 23315 "https://example.com/ords/r/workspace/app/513?session=16341982594912" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:144.0) Gecko/20100101 Firefox/144.0" 66 - - 100:513

Successful:
1.2.3.4 - [21/Oct/2025:19:36:13 +0000] "GET /ords/apex_util.get_blob?s=16341982594912&a=100&c=12100668214905604&p=513&k1=861&k2=&ck=FJEhzop0GMbeiLr2EfCHiTBMG1w7zRhEHfRpW-RVAVqRSSNgFPafrltjK71_jHjFNlD1icQOgoGcNE-K-3VAdQ&rt=CR HTTP/2.0" 200 35721 "https://example.com/ords/r/workspace/app/513?session=16341982594912" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:144.0) Gecko/20100101 Firefox/144.0" 102 - - 100:513

The failed request is repeated several times.

Nothing appears in the ORDs server logs.

Comments
Post Details
Added 29 hours ago
0 comments
42 views