Re: Display CLOB content on AL32UTF8

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Sat, 30 Dec 2006 23:35:18 +0100
Message-ID: <en5f7d$sl7$2@news2.zwoll1.ov.home.nl>

rios schreef:
> "Frank van Bortel"

>> Looks like you're bitten by implicit conversion (and you forgot
>> to do your homework :))

>
>
> thanks
> I've resolved this by calling
> dbms_lob.loadCLOBfromfile
> instead and supplied "nls_charset_id('AL32UTF8')" to the parameter
> "BFILE_CSID"
>
>
> SQL> desc dbms_lob.loadCLOBfromfile
> Parameter Type Mode Default?
> ------------ ------ ------ --------
> DEST_LOB CLOB IN OUT
> SRC_BFILE BFILE IN
> AMOUNT NUMBER IN
> DEST_OFFSET NUMBER IN OUT
> SRC_OFFSET NUMBER IN OUT
> BFILE_CSID NUMBER IN
> LANG_CONTEXT NUMBER IN OUT
> WARNING NUMBER OUT
>
>

Appreciate the feedback. A prosperous 2007!

-- 
Regards,
Frank van Bortel

Top-posting is one way to shut me up...

Received on Sat Dec 30 2006 - 16:35:18 CST