播放存储在 blob 中的 oracle 数据库中的视频 - Oracle Apex [英] Play video from oracle database stored in blob - Oracle Apex

问题描述

是否可以在 oracle apex 的播放器(交互式报告或 plsql 动态内容)中加载 blob(视频)?

Is it possible load blob (video) in player (interactive report or plsql dynamic content) in oracle apex?

例如:

select 
ID, 
NAME,
decode(NVL(dbms_lob.getlength("BLOB"),0),0,NULL,
       '<video width="400" controls><source src="' ||apex_util.get_blob_file_src('P18_BLOB',IMG_ID)||'" type="video/mp4"></video>') "VIDEO"
from VIDEO;

推荐答案

点击查看运行时间图像用于交互式报告:

(1) Create ITEM (in this example - P3_VIDEO)
    Type: Hidden
    Source: Type => Database Column
            Database Column => Your blob column in the table that has video content
    Used: Always replacing existing value in session state.

(2)Create ITEM (in this example - P3_ID)
    Type: Hidden
    Source: Type => Database Column
            Database Column => Primary key column of the table has video content
    Used: Always replacing existing value in session state.

 (3)Create a page process
    Type: Automatic Row Fetch
    Table name: Your table that has video content
    Primary Key Column: Primary key column of the table has video content
    Primary Key Item: P3_ID (In this example)
        
 (4) SQL Query of the IR
       SELECT ID,'<video width="320" height="240" controls>
       <source src="'||apex_util.get_blob_file_src ('P3_VIDEO',ID, 
       p_content_disposition => 'inline')||'" type="video/mp4">
       our browser does not support the video tag.
       </video>' as VIDEO
       FROM VIDEO;
  
 (5) select the column - VIDEO (in this example)
     Type - Plain Text
     Security - Escape Special Characters - No
  

这篇关于播放存储在 blob 中的 oracle 数据库中的视频 - Oracle Apex的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！