To understand the maximum characters allowed in the oracle DB
Is that 2000 characters are only allowed in the oracle database?
User is trying to convert Oracle BLOB type columns to string with the Oracle native function dbms_lob.substr(Column_Name,2000,1).
The above is trimming the data to 2000 characters.
It throws error as - "SQL Error [6502] [65000]: ORA-06502: PL/SQL: numeric or value error: raw variable length too long
ORA-06512: at line 1".
Oracle version - Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
We want to understand the limitation for this function or any alternate way to the same.