Re: Copy Blob data into Varchar2

  • From: "Sanjay Mishra" <dmarc-noreply@xxxxxxxxxxxxx> (Redacted sender "smishra_97" for DMARC)
  • To: Oracle-L Freelists <oracle-l@xxxxxxxxxxxxx>, Jonathan Lewis <jonathan@xxxxxxxxxxxxxxxxxx>
  • Date: Thu, 26 Mar 2020 00:52:15 +0000 (UTC)

 Thanks Jon for the information. 
Sanjay
    On Wednesday, March 25, 2020, 11:29:17 AM EDT, Jonathan Lewis 
<jonathan@xxxxxxxxxxxxxxxxxx> wrote:  
 
 
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


What version of Oracle? In the limits section of the manual for 11g, the
VARCHAR2 data type is limited to 4,000 bytes. Check the "Reference"
manual for your version.

For version 12 it's also 4,000 but can be 32,767 if you have set
MAX_STRING_SIZE to EXTENDED in the spfile.


Cheers,
Norm.

--
Norman Dunbar
Dunbar IT Consultants Ltd

Registered address:
27a Lidget Hill
Pudsey
West Yorkshire
United Kingdom
LS28 7LG

Company Number: 05132767
--
//www.freelists.org/webpage/oracle-l



--
//www.freelists.org/webpage/oracle-l

  

Other related posts: