A further detail to the max_string_size setting - you have to be in upgrade
mode and run an upgrade script to enable it, and you can't downgrade the
database afterwards.
See the 12.2 reference manual on the parameter for details:
https://docs.oracle.com/database/121/REFRN/GUID-D424D23B-0933-425F-BC69-9C0E6724693C.htm#REFRN10321
Regards
Jonathan Lewis
________________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx <oracle-l-bounce@xxxxxxxxxxxxx> on behalf
of Sanjay Mishra <dmarc-noreply@xxxxxxxxxxxxx>
Sent: 25 March 2020 15:19
To: dmarc-noreply@xxxxxxxxxxxxx; Oracle-L Freelists; Norman Dunbar
Subject: Re: Copy Blob data into Varchar2
Thanks Norman, Db is 12.2 but maxsize is not extended. I will test on Sandbox
and test it.
Sanjay
On Wednesday, March 25, 2020, 04:49:45 AM EDT, Norman Dunbar
<oracle@xxxxxxxxxxxxxxx> wrote:
On 25/03/2020 03:14, Sanjay Mishra (Redacted sender smishra_97 for
DMARC) wrote:
ORA-06502: PL/SQL: numeric or value error: character string buffer too small