Home » Applications » Oracle Fusion Apps & E-Business Suite » ERROR:ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ERROR:ORA-06502: PL/SQL: numeric or value error: character string buffer too small [message #216973] Wed, 31 January 2007 02:18
bk39617
Messages: 1
Registered: January 2007
Junior Member
Hi all,
whenever iam trying to fetch clob data from a table it is giving ORA-06502: PL/SQL: numeric or value error: character string buffer too small.

Query is:select DBMS_LOB.SUBSTR(Column Name,DBMS_LOB.GETLENGTH(Column),1) from Tablename where CONDITION CLAUSE.


Please provide me your valuable inputs regarding the above error.


Thank You
Balakrishna
Previous Topic: performance Management Issue
Next Topic: PO closing script
Goto Forum:
  


Current Time: Tue Dec 06 04:50:14 CST 2016

Total time taken to generate the page: 0.08764 seconds