Copy Blob data into Varchar2
From: Sanjay Mishra <"Sanjay>
Date: Wed, 25 Mar 2020 03:14:18 +0000 (UTC)
Message-ID: <926860455.1744600.1585106058799_at_mail.yahoo.com>
Date: Wed, 25 Mar 2020 03:14:18 +0000 (UTC)
Message-ID: <926860455.1744600.1585106058799_at_mail.yahoo.com>
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
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Mar 25 2020 - 04:14:18 CET