Re: Copy Blob data into Varchar2
- From: "Sanjay Mishra" <dmarc-noreply@xxxxxxxxxxxxx> (Redacted sender "smishra_97" for DMARC)
- To: dmarc-noreply@xxxxxxxxxxxxx, Oracle-L Freelists <oracle-l@xxxxxxxxxxxxx>, Norman Dunbar <oracle@xxxxxxxxxxxxxxx>
- Date: Wed, 25 Mar 2020 15:19:16 +0000 (UTC)
Thanks Norman, Db is 12.2 but maxsize is not extended. I will test on Sandbox
and test it.
On Wednesday, March 25, 2020, 04:49:45 AM EDT, Norman Dunbar
On 25/03/2020 03:14, Sanjay Mishra (Redacted sender smishra_97 for
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.
Dunbar IT Consultants Ltd
27a Lidget Hill
Company Number: 05132767
Other related posts: