Home » Other » 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: 566
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
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: 68625
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: 566
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
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: 68625
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: Thu Mar 28 11:34:21 CDT 2024