Skip to Main Content

SQL & PL/SQL

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 insert simple image into blob datatype

user5716448Mar 12 2021

Hi,

wanting to test a report tool to check it shows signature correctly which will be passed to us as blob but not got any real data yet.

Trying below
blob table 2 columns
employee number, image_signature.
insert into blob table values(2, hextoraw('C9CBBBCCCEB9C8CABCCCCEB9C9CBBB'));

Anyone know/have example hex of simple image ideally signature squiggle or similar just a pic of some sort can check if gets blob data inserted correctly.

Not sure of any other way we could insert test bob data?

Thanks

Comments
Post Details
Added on Mar 12 2021
2 comments
8,486 views