DBMS_LOB.SUBSTR 操作的问题!
我写以下语句的时候就报这个错:numeric or value : string buffer too small !
SELECT sales,DBMS_LOB.SUBSTR(content,2000, 1) content FROM A where A.id = '123456789'
我把2000 改为 1000,就不抱错了如:
SELECT sales,DBMS_LOB.SUBSTR(content,1000, 1) content FROM A where A.id = '123456789'
怎么解决呢?????