Skip to Main Content
Forums

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 show video stored in a blob column

Hi all, I'm on Oracle always free cloud, so APEX version is 21.1.6.
I have a table in which in a blob column I can store audio file, image file and video file.
What I want is to show or download video file from this database blob column.
I have already search here in the forum and on internet, but I haven't find any solution.
Can someone help me, showing some examples or giving me some links to find solution for my problem?
Thanks in advance, Fabrizio
This post has been answered by Fabrizio Delli Priscoli on Nov 23 2021
Jump to Answer

Comments

fac586

Help us to help you—get as far as you can in reproducing your problem on apex.oracle.com and share guest developer credentials for the workspace so we can build on that to demonstrate potential solutions.

I have seen this post in the forum...
undefined (0 Bytes)But first plugin is referred only for image... and second plugin, if you look in the SQL source region in the demo app, it refers to a path, where in my situation I have column of my table.

SELECT '/web/path/to/my/video.mp4' AS video_url,

'/web/path/to/my/poster.png' AS poster_url,

'video/mp4' AS mime_type,

'/web/path/to/my/video.webm' AS alternative_video_url,

'video/webm' AS alternative_mime_type

FROM dual
fac586

But first plugin is referred only for image... and second plugin, if you look in the SQL source region in the demo app, it refers to a path, where in my situation I have column of my table.
Right. So far there is nothing to indicate that plug-ins of any type are required, but we do need to know exactly what you are working with, and the best way to find out is by seeing a realistic example on apex.oracle.com.

SmithJohn45

@fabrizio-delli-priscoli
may be this can help.
Play video from oracle database stored in blob - Oracle Apex (0 Bytes)

Answer

Recently on apex.world was published an article on how to manage files on object store.
Here is the link:
Come gestire i files su Object Storage da Oracle APEX (0 Bytes)
So, after reading this article I decided to adopt this solution.
And now for video files I store them directly on cloud.
Thanks all for your help and attention.
Fabrizio

Marked as Answer by Fabrizio Delli Priscoli · Nov 23 2021
1 - 5

Post Details

Added on Nov 21 2021
#apex-discussions
5 comments
1,290 views
1 mention