Version: 5.1.1.00.08
Theme: Universal
DB: Oracle Database 12c Standard Edition Release 12.1.0.2.0 - 64bit Production
Hello,
I having an issue with a video (MP4) playing in IE 11 and of course it works perfectly in Firefox 54.0.1 (64-bit) and Chrome 59.0.3071.115 (Official Build) (64-bit).
I found this post, https://community.oracle.com/message/10830743, and in the second reply by Ramesh P. he provides code to play a video.
So I created an Application Process called Get_Video:
BEGIN
get\_video (:P8\_FILE\_INDEX);
END;
I created a procedure called GET_VIDEO:
CREATE OR REPLACE PROCEDURE get_video (pfileid IN NUMBER)
IS
v\_blob BLOB;
v\_length NUMBER;
v\_mime\_type VARCHAR2 (300);
v\_file\_name VARCHAR2 (200);
BEGIN
-- get pdf\_data and its mime type from the database
SELECT blob\_content
,file\_mimetype
,file\_name
INTO v\_blob
,v\_mime\_type
,v\_file\_name
FROM ib\_assets
WHERE file\_index = pfileid;
v\_length := DBMS\_LOB.getlength (v\_blob);
OWA\_UTIL.mime\_header
(
v\_mime\_type
,FALSE
);
HTP.p ('Content-length: ' || v\_length);
HTP.p ('Content-Disposition: filename="' || v\_file\_name || '"');
OWA\_UTIL.http\_header\_close;
WPG\_DOCLOAD.download\_file (v\_blob);
EXCEPTION
WHEN OTHERS THEN
raise\_application\_error
(
-20001
,'Error: ' || SQLERRM
);
END get_video;
The calling page is a Classic report with an icon of the blob column from the table that contains the blob and calls a Modal Window to play the video. From Firefox and Chrome the Modal Window opens and a player is displayed with the video.
Within the query for the report I have:
SELECT
...
,CASE
WHEN NVL (DBMS\_LOB.getlength (blob\_content), 0) = 0 THEN NULL
ELSE CASE WHEN file\_mimetype LIKE '%mp4' THEN DECODE
(
NVL (DBMS\_LOB.getlength (blob\_content), 0)
,0, NULL
,'\<a href=" '
|| APEX\_UTIL.prepare\_url ('f?p=' || :APP\_ID || ':8:' || :APP\_SESSION || ':APPLICATION\_PROCESS=GET\_VIDEO:' || :DEBUG || '::P8\_FILE\_INDEX:' || file\_index)
|| ' ">\<img alt=" '
|| file\_name
|| '" title="'
|| file\_name
|| '" src="&APP\_IMAGES.mp4-icon.png" '
|| '" height="75" width="75" /> '
)
...
FROM ...
From IE I get two windows that open. 1 is the Modal Window that opens a player that displays in Firefox and Chome the other is Windows Media Player.
The error message I get from IE is:
Can someone help me with getting this video to play in IE too?
What else can I provide?
Thanks,
Joe