Skip to Main Content
Forums

APEX

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!

How to save an image from a DIV to oracle BLOB column

SiberiaNov 8 2015 — edited Nov 8 2015

Hi Apex Community:

i have a DIV section in my Oracle Apex (Application Express 5.0.0.00.31) page :

<br />

<div id="editor-box-img" class="target" contenteditable="true">

</div>


i am able to paste images from clipboard to this DIV, so i want to know how can i save this image to my oracle database table ??.

The table structure is a very simple demo:

create table blob_test (

id number,

blob_content blob,

mime_type varchar2(1000),

file_name varchar2(1000),

constraint blob_test_pk primary key(id)

)

/

any help will be highly appreciated.

Thanks

Mj

Comments

Kalesh Ravi-Oracle

Currently where is it stored? In your file system ?

Siberia

Hi Kalesh.

No, actually the image is pasted directly from clipboard into DIV, once it is pasted, i want to save it to Oracle Database.

Kalesh Ravi-Oracle

Hi Siberia, Can you please reproduce what you are trying to do in apex.oracle.com. That will give us more information on what exactly you are looking for. -Kalesh.

Siberia

Ok Kalesh, at this time all i have is a simple page that use this nice script that let me paste into HTML directly from clipboard:  Edit fiddle - JSFiddle

all i need is to save the pasted image into my oracle table.

please take a look at the jsfiddle script and comment.

i have not an account on apex.oracle.com at this time

thanks

1 - 4
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Dec 6 2015
Added on Nov 8 2015
#apex-discussions, #image
4 comments
1,619 views