Hi - I am trying to load an image (.jpg) to a BLOB field from a local directory.
But when I double-click on the BLOB field (after a select) the 'View Value' pop-up box always has the 'Load' greyed-out, so unavailable.
It looks like I haven't got the correct privilege - but I just created the table and the current row ?!
Anyone got any suggestions ?
SQL Developer Version 3.2.20.09
Oracle Database 11g Enterprise Edition 11.2.0.3.0 64bit Production
create table PETEHTEST5
(APPLICATION VARCHAR2(50) ,
TOPIC VARCHAR2(50) ,
TYPE NUMBER ,
SEGMENT NUMBER ,
DATADW BLOB ,
SYSMODCOUNT NUMBER ,
SYSMODUSER VARCHAR2(20) ,
SYSMODTIME DATE );
table PETEHTEST5 created.
INSERT INTO PETEHTEST5 values ('testnull','test',0,1,NULL,1,'PH',sysdate);
1 rows inserted.
INSERT INTO PETEHTEST5 values ('test','test',0,1,UTL_RAW.CAST_TO_RAW('32aasdasdsdasdasd4e32'),1,'PH',sysdate);
1 rows inserted.
select * from PETEHTEST5
test test 0 1 (BLOB) 1 PH 24-MAR-15
testnull test 0 1 (null) 1 PH 24-MAR-15
Double-clicking on (BLOB) or (null) brings up . . .

Thanks for any help.
Pete H.