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!

Download BLOB - dynamic text link

616718Oct 7 2010
Hi apex users,

I have a report with a standard blob download columns, using the following SQL:

select a, b, filename, minetype, dbms_lob.getlength(blob_column) report_length
from table
*where [...]*

and the following format is applied to the "report_length" column:
DOWNLOAD:BLOB_TABLE:BLOB_COLUMNS:BLOB_ID::MIMETYPE:FILENAME:::inline:Download


It's work fine, but i'd like te personalized the "Download" link, and make it change dynamically:

I've read in the documentation that the link text supports substitutions strings, and try to test with:
DOWNLOAD:BLOB_TABLE:BLOB_COLUMN:BLOB_ID::MIMETYPE:FILENAME:::inline:#OWNER#
and it's work fine.

But what I want is to diplay the a column of my sql query:
DOWNLOAD:BLOB_TABLE:BLOB_COLUMN:BLOB_ID::MIMETYPE:FILENAME:::inline:#A#
DOWNLOAD:BLOB_TABLE:BLOB_COLUMN:BLOB_ID::MIMETYPE:FILENAME:::inline:#COL01#

But doesn't work. Am i missing something?

AkA
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 4 2010
Added on Oct 7 2010
0 comments
336 views