How to get Binary equivalent of BLOB data type in Oracle

Question

I am using C# for front end and Oracle as a database. I have a BLOB type field in a table and is used to contain images. What I actually need to do is that whenever a record in table doesn't contain any image I want to show default pic for that particular record in front end. For that purpose can I get a binary format of that default image(without saving that image with a dummy record) after saving it temporarily in database, and then using that binary format in query to show default pic when the image doesn't exists for any record. What I am getting now is :

 SELECT EMP_IMG FROM Employee_Master WHERE EMP_CODE = 1234
 ----------------------------------------------------------
 (BLOB)

So... is the problem that your command line tool doesn't show BLOB contents? — Ignacio Vazquez-Abrams
– Ignacio Vazquez-Abrams, Commented Apr 24, 2012 at 4:22

Community · Accepted Answer · 2017-05-23 12:03:17Z

0

Look into byte[]; use Binary Serializer to get the byte[] version of the object. See this: C# Object Binary Serialization

edited May 23, 2017 at 12:03

CommunityBot

11 silver badge

answered Apr 24, 2012 at 4:31

Matt

27.1k67 gold badges205 silver badges319 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Ajendra Prasad Over a year ago

hi @Matt I have used following line in front end but unable to get values in a single line instead in .NET values are shown indexed wise image = (byte[])cmd.ExecuteScalar();

Collectives™ on Stack Overflow

How to get Binary equivalent of BLOB data type in Oracle

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related