When Executing modplsql procedure Using ORDS Content-type (Mime-type) Is Not Picked While Opening a .doc or .excel or .pdf etc., from Executing modplsql procedure (Doc ID 2953978.1)

Last updated on JUNE 13, 2023

Applies to:

Symptoms

On : 21.2 version, All Issues

content-type (mime-type) is not getting picked up by ORDS

https://hostname/pls/schema-name/packagename.procedurename

is called and it works fine and output is displayed.

It has some list of links with .doc, .pdf , etc.,

When those links are clicked, it opens the following URL and after that actually it should open the doc or pdf or excel accordingly :

https://hostname/pls/schema-name/packagename.procedurename?attach_id=<id number> ---------------> Each link has it's own attach_id linked to it (From Database tables)

Using ORDS when the link is clicked in output of parent URL, a new browser is opened and above URL is seen with 500 internal error and no doc or pdf or excel is opened.

But if mime-type is included for those URLs (from database side- in the procedure code itself ), it works fine opening the doc or pdf but no data seen inside it.

Issue is why ORDS is not picking mime-type

ERROR
-----------------------
500 Internal Server Error

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.