JDE how to convert F983051.VRPODATA (long / blob) to a string (varchar2)? I’m not sure if I can do something like: Where FUNCTION is something that converts the BLOB file into a varchar2. P.d. I cannot use any kind of DDL. Please advise, Answer I actually found what I wanted: DBMS_LOB.SUBSTR({BLOB field}). That field can help you for BLOB &