O'Reilly logo

Oracle APEX Cookbook - Second Edition by Marcel Van Der Plas, Michel Van Zoest

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Uploading images using the camera on the device

All smartphones have several kinds of hardware on board. One of the most common pieces of hardware is a camera.

In this recipe we are going to see how we can use the onboard camera of a smartphone to take a picture and automatically store it to the database.

Getting ready

For this recipe we are going to need a jQuery Mobile Smartphone application. And also we need a table to store the data.

The table needs to hold some required columns. They can be created by using the following scripts:

CREATE TABLE  "APP_IMAGES" 
   (   
   "ID" number,
   "PICTURE" BLOB, 
   "MIMETYPE" VARCHAR2(255), 
   "FILENAME" VARCHAR2(255), 
   "IMAGE_LAST_UPDATE" DATE
   ) ;
[9672_14_05.txt]

How to do it...

When the table APP_IMAGES is available, we can start ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required