On Tue, Jan 07, 2003 at 10:22:19AM -0500, [EMAIL PROTECTED] wrote: > Dear Tim Bunce: > > I've been porting a number of my company's apps from Sybase to Oracle, > using DBI as the primary database interface, and ran into a problem I hope > you can help me with; I haven't gotten useful answers on the newsgroups. > > A lot of the work here deals with genome sequences stored as LOBs. Often > we only want a particular substring of the LOB, rather than an entire > sequence, which may be gigabytes long. Do you know of a way to do this > with SQL? Or, perhaps, stored procedures? All the approaches I've tried > thus far have run into limitations in the sizes handled by string-handling > methods in Oracle.
Take a look at the Oracle::OCI module. Espaciall the test scripts. One of them demonstrates reading and writing substrings of a LOB. (The code isn't ready for production use but you're welcome to help make it so :) Tim.