Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- --Oracle a better way to convert a blob to varchar2 when the text is greater than 2000 characters.
- UTL_RAW.CAST_TO_VARCHAR2(DBMS_LOB.SUBSTR(R2.RSPNS_BINARY,2000,1))||UTL_RAW.CAST_TO_VARCHAR2(DBMS_LOB.SUBSTR(R2.RSPNS_BINARY,4000,2001)) AS RSP_Text
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement