calculating the size of CLOB in a database - SQL Syntax query

From: Donald <anon_at_anon.anon.com>
Date: Tue, 4 Nov 2003 12:26:49 -0000
Message-Id: <1067948804.56609.0@eunomia.uk.clara.net>

Hi, rate19Lob is a CLOB. I want to know the total size of all of them in a table in my database. I have run up against a problem. Any ideas to get around it. Please excuse this post if it is simple, I'm new to this and have tried the approach because of what I have read in Oracle DBMS_LOB. Thank you
Don

SQL>
SQL>
SQL> SELECT SUM(DBMS_LOB.GETLENGTH(rate19Lob))
  2      FROM tbl_JNY2003;
SELECT SUM(DBMS_LOB.GETLENGTH(rate19Lob))
           *

ERROR at line 1:
ORA-06552: PL/SQL: Compilation unit analysis terminated ORA-06553: PLS-553: character set name is not recognized

SQL>
SQL>
SQL> SELECT * FROM V$VERSION;

BANNER

---

Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production PL/SQL Release 8.1.7.0.0 - Production
CORE 8.1.7.0.0 Production
TNS for 32-bit Windows: Version 8.1.7.0.0 - Production NLSRTL Version 3.4.1.0.0 - Production

SQL> Received on Tue Nov 04 2003 - 06:26:49 CST