Oracle REST Data Services (ORDS) : RESTful Web Services Handling Media Files

In this video we'll demonstrate how to handle media files (images, sound, video, binary files) using Oracle REST Data Services (ORDS)

Oracle REST Data Services (ORDS) : RESTful Web Services Handling Media (Documents and Images)

Oracle REST Data Services (ORDS) : Create Basic RESTful Web Services Using PL/SQL

Oracle REST Data Services (ORDS) : All Articles

Cameo by Katrina Shallahamer :

Cameo appearances are for fun, not an endorsement of the content of this video.

All trademarks, product names and logos are the property of their respective owners.

[viswapsp]

Also, I would like to know how we can send few other attributes in the body (in addition to a blob). For example, I have a table emp, that contains empno, ename, sal, photo, fingerprint (2 blob columns, and few text/number/date columns). If I want do a POST, how can I send send column values, along with the two blobs (not necessarily of the same content type) in the body how can I do. (I personally prefer not to send the actual column values in HEADER, even though it appears when sending in HEADER seems working. Of course, I still have questions on how to send two blob values). Can you help me. Thank you.

[viswapsp]

Tim - I have looked at several videos related to REST services (ORDS). The content, presentation as well as the speed are is precise. You have made my day. Thank you for posting those. Also, I do look at Oracle-Base.com very regularly and they are all great. BTW, I have a question, I see the content-type, and the filename are Header parameters and I am not sure what if I have to upload multiple files and they are of different types (as well as different names). For example: a PDF file, and an Excel sheet. I like my users to have a single submission. Is there any way you can suggest?

[sankalpgupta]

Tim, is there a way to find mimetype of uploaded file ?

[santoclemenzi]

Hi Tim! Very good explanation! I have a problem trying to import a pdf file: everything works fine but when I download back the uploaded pdf it result in a blank pdf file. I also tried with a xlsx file and it seems to be corrupted when I download it. Is it possible that the implicit parameter "body" must be encoded somehow before proceding with the INSERT? Thank you very much!

[clenton]

Hey Tim, Thanks for your awesome contents. I would like to know some suggestions on how handle exceptions for GET methods with Source type as Media. Because in this case if the query doesn't return any values I want show error message instead 500 Internal Server error. I can able to achieve these on POST but not on GET. Looking forward to your suggestions.

[grandma-story]

well done but if i have multiple files how to do it