Skip to Main Content

SQL Developer

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!

BLOB load unavailable (greyed out)

077f6001-1eb9-4378-bf54-7c772488f359Mar 24 2015 — edited Mar 24 2015

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 . . .

pastedImage_2.png

Thanks for any help.

Pete H.

This post has been answered by thatJeffSmith-Oracle on Mar 24 2015
Jump to Answer

Comments

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

Post Details

Locked on Apr 21 2015
Added on Mar 24 2015
5 comments
2,967 views