OraFAQ Forum: Client Tools » set markup html on

Home » SQL & PL/SQL » Client Tools » set markup html on (Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

set markup html on [message #648295]

Fri, 19 February 2016 14:48

manubatham20
Messages: 562
Registered: September 2010
Location: Seattle, WA, USA

Senior Member

Hi,

Can "set markup html on" be used for displaying images stored as BLOB.
Currently it's giving me Hex Truncated Blob data.

Will this work, or should I go through dbms_xmlgen procedure.

Thanks,
Manu

Report message to a moderator

Re: set markup html on [message #648296 is a reply to message #648295]

Fri, 19 February 2016 15:05

Michel Cadot
Messages: 67640
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Quote:

Can "set markup html on" be used for displaying images stored as BLOB.

No, SQL*Plus does not know what's inside a BLOB, for it it is binary data and so does its best displaying it at hexadecimal string.

Quote:

Currently it's giving me Hex Truncated Blob data.

What is "it"?

Quote:

Will this work, or should I go through dbms_xmlgen procedure.

What is the relation between BLOB and DBMS_XMLGEN?

Report message to a moderator

Re: set markup html on [message #648304 is a reply to message #648296]

Fri, 19 February 2016 18:41

manubatham20
Messages: 562
Registered: September 2010
Location: Seattle, WA, USA

Senior Member

Yes, but it was not giving me whole Hexadecimal corresponding to BLOB, seems like it was truncated to show first few.

So I was thinking to get an html file using oracle dbms xml in-built functions with encoded Hex strings, and using javascript to decode hex to image on fly.

Thanks,
Manu

Report message to a moderator

Re: set markup html on [message #648308 is a reply to message #648304]

Sat, 20 February 2016 01:06

Michel Cadot
Messages: 67640
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

SET LONG

Report message to a moderator

Previous Topic:	ORACLE not available; Shared memory realm does not exist
Next Topic:	using a prompt as a column

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Jan 18 04:38:05 CST 2021