Re: BLOBs

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: 1999/10/13
Message-ID: <SLQEOPEqSAP6x4qB1UVHuIipN9P6@4ax.com>#1/1

A copy of this was sent to "Geert Van Muylem" <Geert.Van.Muylem_at_UTIMACO.BE> (if that email address didn't require changing) On Wed, 13 Oct 1999 16:33:18 +0200, you wrote:

>How can I see the contents of a blob-field?
>
>Ragards,
>
>

scott_at_8i> select utl_raw.cast_to_varchar2( dbms_lob.substr(image,200,1) ) from image
  2 where name = 'SampleMovie';

UTL_RAW.CAST_TO_VARCHAR2(DBMS_LOB.SUBSTR(IMAGE,200,1))

---

  @moov 8cmov

                 dcomzlib  $cmvd

øx?µTÏkA~»?¦?U[K???î¡`5RÛK¤Ø?F?h !öà?Ý?¥»Ù?ÝDü?½?õÒ?= Z¨(xÚ[ÿ

       ? ?/zý^f7ÙDZ¼8í×?yóæ{;ｯDѶã4?Ȳ?3½?þù?A$_%ê??ãoê
¯®­`½ì­´b"Þc3`CÜÞñ/                                      ?ºGÏ>M¿

BEWARE -- it'll put binary stuff on your screen and might really mess up your terminal emulator (mine just did)

UTL_RAW is part of Oracle, it might not be installed (its installed with replication and the procedural gateways. If it is not installed, goto your $ORACLE_HOME/rdbms/admin directory, find the files:

prvtrawb.plb utlraw.sql

and then using SVRMGRL when connected as INTERNAL or SYS (only that tool, only those users please) install

SVRMGRL> @utlraw
SVRMGRL> @prvtrawb.plb

then you will have utl_raw.

-- 
See http://osi.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'...
Current article is "Part I of V, Autonomous Transactions" updated June 21'st
 
Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation

Received on Wed Oct 13 1999 - 00:00:00 CDT