Re: SELECT a CLOB?

From: XXX <XXXX_at_XXX.XXX>
Date: Tue, 21 Mar 2000 13:22:14 +0100
Message-ID: <8b7pdh$2gq$1@scesie13.sie.siemens.at>

try :

select dbms_lob.substr(CLOB,1,MAXDATA) .... this function returns RAW data, I did not try it, but I think it will be OK

Vasek

kev <kevin.porter_at_fast.no> píse v diskusním pøíspìvku:38D63AF5.B41F8599_at_fast.no...
> Hi,
>
> I've converted my LONGs to CLOBs, but don't know how to SELECT the data
> without getting "Inconsistent datatypes" errors. What's the correct way
> of SELECTing this data?
>
> thanks,
>
> - Kev
>
Received on Tue Mar 21 2000 - 06:22:14 CST