Home » SQL & PL/SQL » Client Tools » set markup html on (Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production)
set markup html on [message #648295] Fri, 19 February 2016 14:48 Go to next message
manubatham20
Messages: 558
Registered: September 2010
Location: Minneapolis, MN, 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
Re: set markup html on [message #648296 is a reply to message #648295] Fri, 19 February 2016 15:05 Go to previous messageGo to next message
Michel Cadot
Messages: 65849
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?

Re: set markup html on [message #648304 is a reply to message #648296] Fri, 19 February 2016 18:41 Go to previous messageGo to next message
manubatham20
Messages: 558
Registered: September 2010
Location: Minneapolis, MN, 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
Re: set markup html on [message #648308 is a reply to message #648304] Sat, 20 February 2016 01:06 Go to previous message
Michel Cadot
Messages: 65849
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

SET LONG

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


Current Time: Sun Oct 21 20:49:17 CDT 2018