Database Administration (MOSC)

MOSC Banner

Unable to convert blob to text

So recipe is a blob column, i was trying to read this blob data. Tried SQL Developer

select utl_raw.cast_to_varchar2(dbms_lob.substr(recipe,4000,1)) from RMS_PNG.RMS_GOLDENRECIPE where toolid = 'DEK-04' and recipeid='31018';

ORA-06502: PL/SQL: numeric or value error: raw variable length too long

ORA-06512: at line 1

06502. 00000 - "PL/SQL: numeric or value error%s"

*Cause:  An arithmetic, numeric, string, conversion, or constraint error

      occurred. For example, this error occurs if an attempt is made to

      assign the value NULL to a variable declared NOT NULL, or if an

      attempt is made to assign an integer larger than 99 to a variable

Tagged:

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