Re: BLOB, CLOB, NCLOB Datatype

Hi Alan,

Alan wrote:
>
> HI,
>
> My I know whether BLOB, CLOB, NCLOB datatype is supported by Oracle 8 Server
> 8.1.5?

The answer is Yes.

>
> If I want to insert and image into Oracle server into a BLOB field, how can
> I do so? by SQL?? or any other way?

You can do that by SQL*Loader, by DBMS_LOB package etc.

Have a look at "Oracle8i Application Developer's Guide - Large Objects" part number A68004-01 and at "Oracle8i Utilities" (A67792-01).

> and How can I do it it Perl? i.e. use
> perl to insert an image into the oracle database

I don't know. Sorry.

>
> Thank You
>
> Alan

Hope that helps.

P.S. Nobody was serious here because of your English, I guess...

-- 
Valeri Sorokine
Oracle Certified Application Developer, Rel.2
ProSoft, Russia, Moscow, Information Systems Division
Phone: +7 (095) 234 0636 ; FAX: +7 (095) 234 0640
E-mail: vsorokin_at_dd.ru   ; http://www.dd.ru