Online urgent! Read the CLOB fields, string buffer is too small, how to solve?-CodePudding

Home > database > Online urgent! Read the CLOB fields, string buffer is too small, how to solve?

Online urgent! Read the CLOB fields, string buffer is too small, how to solve?

Time：09-25

The great god, I'm in the query a CLOB types of fields, field content of more than 4000 bytes, how can the CLOB fields into varchar2 type?

CodePudding user response:

Split into multiple var. 4000

CodePudding user response:

How do you break up? Bother in detail

CodePudding user response:

Want to use dbms_lob package, some of the methods, you can check and see which suits