Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

DBMS_LOB.SUBSTR with NCLOB data type

venkatraman.LDec 27 2012 — edited Dec 27 2012
Hi ,


When I am trying to extract part of the string from Comments column(NCLOB datatype) am facing issue.

ORA-06502:PL/SQL Numeric or value error :Character string buffer too small

select dbms_lob.substr(a.COMMENTS, 4000, 1),
from VW_DETAILS a
where a.id = 6210872


DBMS_LOB.SUBSTR with NCLOB data type

Table structure :

Column_name Data_type
Comments NCLOB
ID NUMBER



Regards,
Venkat
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 24 2013
Added on Dec 27 2012
2 comments
707 views