Skip to Main Content

Developer Community

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!

Display video from BLOB column in Oracle 19c using Oracle forms12c button

Engineerr1983Mar 10 2024

Hi

I'm trying to upload videos to BLOB column in Oracle 19c, I'm using Oracle forms 12c.

I were able to upload Videos or Images to the table using a procedure and a button's trigger, the button name is (upload), but for displaying the video without downloading it to the client machine, I want just to select the video name from a list and play the video directly using the Windows media player, and the code that plays the video would be inside a (When_Button_Pressed_trigger)..

In case I want to download the file before playing the video, I already have a procedure to download the file as shown below.

It should store the file inside a directory in the server machine called (LOB_OUTPUT).

Now, what would be the plsql code inside (When_Button_Pressed_Trigger) to play that video in the (LOB_OUTPUT) directory?

Also, the procedure always download the video file to the (LOB_OUTPUT) directory inside the server not the client, how would I change it to make the download on the client machine not the server.

Thanks

Comments
Post Details
Added on Mar 10 2024
0 comments
220 views