Copy Blob data into Varchar2

  • From: "Sanjay Mishra" <dmarc-noreply@xxxxxxxxxxxxx> (Redacted sender "smishra_97" for DMARC)
  • To: Oracle-L Freelists <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 25 Mar 2020 03:14:18 +0000 (UTC)

Can someone share any function which can allow to insert BLOB data into 
Varchar2 column? Most of the BLOB data is less than 32K but selecting the BLOB 
using dbms_lob.substr( l_cur.mylob, 32000, 1 ) or utl_raw.cast_to_varchar2 gave 
error
ORA-06502: PL/SQL: numeric or value error: character string buffer too small

Can someone share an example to convert data from BLOB to varchar ?
TxSanjay

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 03-2020