I am new to Perl I have been able to search and read names of columns in Oracle DB tables, but what I need is to be able to search the Tables and find "blob data" and 1) determine the blob size and 2) type, then later I will need to extract the blob into a flat file. I see also arrays in oracle how can I see what is contained in the array ? Any help or Ideas ??