SQL & PL/SQL :: ORA-22835 Buffer Too Small For CLOB To CHAR Or BLOB To RAW Conversion?

Recently I came across this issue, which gives me an error as following.

ERROR:
ORA-22835: Buffer too small for CLOB to CHAR or BLOB to RAW conversion (actual: 4907, maximum: 4000)

Now I am running a very simple query against one of the View in our Database.
Query is:

Select Prj_Num,
PM_Comments
From ProjectDetails
Where Rel = ‘2008 10’

What I have discovered so far is one of the field in this view name “PM_Comments” has more than 4000 bytes of information in it, Which is not supported by tools I have available on my computer. I have Oracle SQL Plus, SQL plus Worksheet, Access and Excel installed on my machine. DBA related to this database are stating that the field is working fine and query is executing without error since they are using TOAD for SQL, which does have capabilities to read more than 4000 bytes.

What I have figured out so far is “PM_Comments” is a LOB and SQL plus is having trouble reading this information more than 4000 bytes in one field of information.Because of this diagnosis, I have tried using following queries but it did not useful either.

Select Prj_Num,
Substr (PM_Comments, 1, 4000)
From ProjectDetails
Where Rel = ‘2008 10’

Select Prj_Num,
DBMS_LOB.Substr(PM_Comments, 4000, 1)
From ProjectDetails
Where Rel = ‘2008 10’

But both of the above mentioned queries did not work either. and I get the same ORA-22835 Error.I do not need all of the information in “PM_Comments” field, I only need about first 1000 characters of it.