Thread

Posted on Tue Nov 13 19:03:52 2007 by pcpinkerton
How to find blob data, size and export to flat file
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 ??
Direct Responses: 6454 | Write a response
Posted on Wed Nov 14 14:01:10 2007 by byterock in response to 6447
Re: How to find blob data, size and export to flat file
You would be much better off posting your question to dbi-users@perl.org (you don't need to subscribe in order to post) and you won't be automatically subscribed either. Very few people actually use or view this form for dbi or driver support. dbi-users is where you'll get the best support. To try ans answer your question I think you can do the blob stuff but you have to treat them a lobs and use the lob locater functions in 1.19 see the POD to check out how to do this. As for Varrays I am working on that as we speak and that should be in release 1.20
Write a response