Re: Copy Blob data into Varchar2
From: Norman Dunbar <oracle_at_dunbar-it.co.uk>
Date: Wed, 25 Mar 2020 08:48:42 +0000
Message-ID: <dd03872d-02d7-3ddc-3ac2-c021e5afbc16_at_dunbar-it.co.uk>
Date: Wed, 25 Mar 2020 08:48:42 +0000
Message-ID: <dd03872d-02d7-3ddc-3ac2-c021e5afbc16_at_dunbar-it.co.uk>
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 -- http://www.freelists.org/webpage/oracle-lReceived on Wed Mar 25 2020 - 09:48:42 CET