I am not great with programing procedures and hope that
you can help out. I am attempting to do some sizing
and need to record the sizes of LOBS using
the DBMS_LOB getlength procedure. I have
tried a function that returns the length of the lOBS
(acutually it's a BLOB) one at time when I enter the
record id, has anyone out there written a looping
procedure that will read a record, capture the length for
all of the records in the table ?

This is a production system I don't think I'd to add another table to it
to capture the information, but I'd like to do averages on the numbers
I get.

Examples would be appreciated.
Thanks.

Stephanie Gonos



Oracle LazyDBA home page