Re: How to create a view containin a lblob column

Prem K Mehrotra wrote:

> I have following table containing a blob column:
>
> SQL> desc ltr_body;
> Name Null? Type
> ----------------------------------------- -------- ----------------------------
> LTR_ID NOT NULL VARCHAR2(20)
> LTR_DESC_TXT VARCHAR2(300)
> LTR_BODY_TXT BLOB
> ADD_DT DATE
> ADD_OPER_ID VARCHAR2(25)
> UPDT_DT DATE
> UPDT_OPER_ID VARCHAR2(25)
>
> I want to define a view:
>
> sqlplus login/password << !
> create or replace view vltr_body as
>
> select LTR_ID, LTR_DESC_TXT, blob_uncompress(read(LTR_BODY_TXT) ltr_body_txt,
> ADD_DT, ADD_OPER_ID, UPDT_DT, UPDT_OPER_ID
> from ltr_body;
>
> !
> I get following error:
> SP2-0678: Column or attribute type can not be displayed by SQL*Plus
>
> Is there any way to define a view, so that I can apply my user written function
> to a column which is blob type.

What version of Oracle?

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)