Oracle Apex Signature pad

 Begin 

APEX_COLLECTION.DELETE_COLLECTION(p_collection_name=>'APEX_SIGNATURE');

exception when others then null;

End;

Begin 

APEX_COLLECTION.DELETE_COLLECTION(p_collection_name=>'APEX_SIGNATURE');

exception when others then null;

End;

begin 

for x in (select c001 as filename,

c002 as mine_type,

c001  as dae_created,

blob001 as img_content

from apex_collections

where collection_name='APEX_SIGNATURE');

loop

update HR_EMPLOYEES set 

sig_pic=x.img_content,

sig_file_name=x.filename,

sig_file_update_date=x.date_created,

sig_file_mine_type=x.mine_type

where pid=:p22_emp_id;

end loop;

end;

create table hr_employees

(

emp_id varchar2(30),

emp_name varchar2(120),

join_date date,

sig_pic  blob,

sig_file_name  varchar2(200),

sig_file_update_date date,

sig_file_mine_type varchar2(50)

)

/