我写以下语句的时候就报这个错: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'怎么解决呢?????
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'怎么解决呢?????
show parameter shared_pool_size;
SELECT sales,DBMS_LOB.SUBSTR(content,dbms_lob.getlength(content), 1) content FROM A where A.id = '123456789'