Re: Display CLOB content on AL32UTF8

From: rios <rios_at_rios.com>
Date: Fri, 29 Dec 2006 23:43:47 -0500
Message-ID: <12pbrk45p2egl6e@corp.supernews.com>

"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 Received on Fri Dec 29 2006 - 22:43:47 CST