How to Write from BLOB to CLOB With Data Containing Multi-Byte Characters
(Doc ID 2314528.1)
Last updated on DECEMBER 19, 2019
Applies to:PL/SQL - Version 220.127.116.11 and later
Generic (Platform Independent)
The following code performs conversion of given BLOB column to CLOB column irrespective of the character-set they are in.
It uses DBMS_LOB.CONVERTTOCLOB Procedure. This Procedure performs the conversion with underlying Character-set in consideration.
The below testing has been done on a Database with AL32UTF8 CharacterSet
How to convert BLOB to CLOB value in a Multi-byte environment ?
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document