SQL & PL/SQL

Hello,

I have a column with a BLOB type and am trying to get the BINARY INTEGER value from it with the following function.

SELECT UTL_RAW.CAST_TO_BINARY_INTEGER(DBMS_LOB.SUBSTR($MY_BLOB_COLUMN)) FROM $MY_TABLE;

For some records, the value is too large (UTL_RAW.SUBSTR function returns a string that is about 1800 chars in length) and because of that, I'm getting the following error.

ORA-06502: PL/SQL: numeric or value error
ORA-06512: at "SYS.UTL_RAW", line 406
ORA-06512: at line 1

Please suggest how binary integers can be retrieved in such cases.

Thanks in advance.