How to find blob data, size and export to flat file

I wanted to build an awesome place for people to discuss module specific issues, but I don't have any more time for this, and there are much better places to discuss Perl-related issues. I'd recommend asking your question on Stack Overflow or on Perl Monks.
If you are looking for a Perl tutorial or Perl-related news, I hope these links will serve you well.

Posted on 2007-11-13 17:03:52-08 by pcpinkerton

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 2007-11-14 12:01:10-08 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

Direct Responses: Write a response