Database Administration (MOSC)

MOSC Banner

To understand the maximum characters allowed in the oracle DB

edited Jul 16, 2024 4:32PM in Database Administration (MOSC) 2 commentsAnswered

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. 

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center