Re: Seeing BLOB by SELECT

From: "alex" <whocare@xxxxx>
Date: Tue, 28 Jun 2005 02:41:59 +0800

In 9iR2
"alex" <whocare@xxxxx> ¦b¶l¥ó news:42c0466d$1_2@xxxxxxxxxxxxxxxx ¤¤¼¶¼g...
> Is it possible to display a BLOB column by SELECT in iSQL*PLUS? I know
> there is a RAWTOHEX() function which accepts both raw & blob types and
> converts them to hex equivalent character values. But I keep on receiving
> these errors:
>
>
> select pk,rawtohex(blobcol) from blobfile
> *
>
> ERROR at line 1:
> ORA-00932: inconsistent datatypes: expected - got BLOB
>
>

.

References:
- Seeing BLOB by SELECT
  - From: alex

Prev by Date: Re: Help with DBMS_LOB
Next by Date: Re: Help with DBMS_LOB
Previous by thread: Seeing BLOB by SELECT
Next by thread: Help With a Decode
Index(es):
- Date
- Thread

Relevant Pages

Seeing BLOB by SELECT
... Is it possible to display a BLOB column by SELECT in iSQL*PLUS? ... there is a RAWTOHEX() function which accepts both raw & blob types and ...
(comp.databases.oracle.misc)
Re: Display DB Image
... >I have an image stored in a SQL DB how can I display it in a control on a ... >Windows Form? ... Read and Write a File to and from a BLOB Column by Using ADO.NET and ...
(microsoft.public.dotnet.languages.vb)
Re: How can I save the SQL image from PictureBox
... "kenken" schrieb: ... and display it on a PictureBox control. ... Read and Write a File to and from a BLOB Column by Using ADO.NET and ...
(microsoft.public.dotnet.languages.vb)