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!

How to use APEX_UTIL.GET_BLOB_FILE_SRC in APEX 19.1 without any Legacy components?

cilyrikMay 23 2020 — edited May 24 2020

In APEX 5.1 what I did was setting up an item of any type (P100_IMG_COL) with source of type "Database Column" and a BLOB column name (T1.IMG) and a page processing of type "Automatic Row Fetch" from table with PK column name (T1.ID) and PK item (P100_IMG_COL). Then I selected images in a Classic Report table with an SQL query, where I called APEX_UTIL.GET_BLOB_FILE_SRC(p_item_name => 'P100_IMG_COL', p_v1 => T1.ID);

I tried to do the same in APEX 19.1, and it still works, but "Automatic Row Fetch" is Legacy, so I would like to know a viable replacement and how to configure it.

I also have some questions to the argument description for GET_BLOB_FILE_SRC. Here's a table of arguments from this documentation:

Parameter	Description
`p_item_name`	Name of valid application page ITEM that with type FILE that contains the source type of DB column.
`p_v1`	Value of primary key column 1.
`p_v2`	Value of primary key column 2.
`p_content_disposition`	Specify `inline` or `attachment`, all other values ignored.

What's "type FILE" for an item? I only found "File Browse..." in "Type".
Why there's two PK arguments - p_v1 and p_v2? How it could be used? I tried to pass arguments to GET_BLOB_FILE_SRC as GET_BLOB_FILE_SRC(p_v1 => t1.id, p_v2 => t1.img), but it compiles with "Wrong set of arguments" error.
What's the difference between p_content_disposition options?

This post has been answered by fac586 on May 23 2020

Jump to Answer

Added on May 23 2020

#apex-discussions, #blob

2 comments

2,740 views