APEX Webcam Plugin
This plugin allows you to receive pictures of a webcam in a PL/SQL execution. I used a jquery plugin from xarg.org.
After installation, t is pretty simple to handle though you have to grab the BLOB from the collection on your own. Create a new page item from the webcam plugin and look at the attribute “PL/SQL execution”.
DECLARE c_collection_name constant varchar2(200) := 'CLOB_CONTENT'; l_blob BLOB; BEGIN select apex_web_service.clobbase642blob(substr(clob001, instr(clob001, ',')+1, length(clob001))) into l_blob from apex_collections where collection_name = c_collection_name; insert into table1(id, img) values (1, l_blob); END;
In the example above a local variable l_blob holds the image and you can easily write it into a table with a BLOB column. Additionally you can pass page/application items to the PL/SQL execution to use them like regular APEX bind parameters.
Requirements: Flash, HTML5 (canvas)
Download item_type_plugin_at_nethead_apex_webcam.sql
Posted from Paris, Île-de-France, France.
very nice Damien
Nice plugin Damien. Thanks.
Damien, how can I apply your concept to integrate the HTML5 ‘Signature Pad’ into APEX? Thanks.
http://thomasjbradley.ca/lab/signature-pad/
You just need to replace the camera-related elements. Through ur plugin is a simple HTML5 canvas, u can read its content and send it to the APEX server the same way like I do.
Mary Oliver’s poem The Journey came into my life when I was seriously ill and in depsarete need of permission to rest. That poem became a talisman, a mentor, a voice ringing with sanity. I have shared it with many, many people over the last 10 years . I’ve yet to encounter another poet whose voice is as pure, clear, lucid, and present. Mary’s poems combine all the wonder of early childhood with the exquisite vision and discernment of someone who deeply, minutely, wildly loves Creation. Her poems are blessings, nothing less.