BLOB size

Hi, I am trying to find out the size of the blob. I have scanned thru the FAQ and archive. I find some suggestions but none of them seems to work in our environment. I try: select blob_name, length(blob_data) from blob_tab;or select blob_name, length(blob_data::lvarchar::clob) from blob_tab; but both sql's return the following error: 674: Routine (length) can not be resolved. Does anyone know how I can get this information? We use IDS 9.30. TIA, Ray

In article <15aa6f7d.0409091110.6a2ca12e@posting.google.com>, Ray Walsh <raywsl@hotmail.com> wrote: >Hi, > >I am trying to find out the size of the blob. I have scanned thru the >FAQ and archive. I find some suggestions but none of them seems to >work in our environment. I try: > >select blob_name, length(blob_data) from blob_tab; Try octet_length(blob_data). Cheers, Jim -- W. Jim Jordan, Nortel Networks 5050 40 Street NE, Calgary, AB T3J 4P8 Canada wjjordan at nortelnetworks dot com +1 403 769 2590 Opinions expressed are not necessarily those of Nortel Networks. -- W. Jim Jordan, Nortel Networks 5050 40 Street NE, Calgary, AB T3J 4P8 Canada wjjordan at nortelnetworks dot com +1 403 769 2590 Opinions expressed are not necessarily those of Nortel Networks.