Skip to Main Content
Feature Request FR-2683
Product Area Page Components
Status CLOSED

28 Voters

Display blob inline (or link) should be possible without specifying dbms_lob.getlength in query.

niels.de.bruijn Public · Aug 11 2022

Problem description
When adding a blob column to an Interactive Report and setting this column to “Download BLOB” or “Display Image”, a nice error message occurs: “ORA-06502: PL/SQL: numeric or value error: character to number conversion error”. Only after adding “dbms_lob.getlength(my_blob)” in the query, it works.

Preferred Solution
I expect the page show the blob/link without having to add dbms_lob.getlength in the query.

We reviewed this idea carefully, and while it was interesting, we concluded that due to all the internal implications we need to take into account, it is unlikely to make its way into APEX.

Comments

Comments

  • jayson hanes Admin OP 2.9 years ago

    Great idea! This has caught me so many times over the years - and it's an especially steep learning curve for new APEX developers

  • patrizia.regenberg OP 2.9 years ago

    This would be a really good improvement!

  • drdalvi OP 2.9 years ago

    Nice Idea….I vote for this Request

  • vincent morneau Admin OP 2.5 years ago

    Hi Niels,

    This is a great idea, and I personally remember thinking the same many times before! We reviewed this and we think it's more likely that future report types allow to map a BLOB column to display an image, just like the Cards Region now. But it's unlikely that older components will be updated to accommodate this.

    Bottom line is, we totally agree to see less of dbms_lob.getlength in future components!

  • danb OP 11 months ago

    Thank the lord for this post. I know better and still spent a bit of time! Thank you.