SQL & PL/SQL

Hi,

I'm trying to find the size of a CLOB column in a table and get the error

PLS-00306: wrong number or types of arguments in call to 'GETLENGTH'

when trying to use dbms_lob.getlength. Here's the code


declare
num number;
begin
for rec in (select xmlupload from FILE_TABLE where file_table_id = 33635) loop
num := dbms_lob.getLength(rec.xmlupload);
end loop;
dbms_output.put_line(num);
end;

Database version: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi


I'm actually trying to find the size of a table with CLOB columns, is there an easy way to do this besides using getlength and without having to contact the DBAs (they are outsourced) ?