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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Jun 30 23:17:12 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.