Re: Re: cvs: pear /MDB2/MDB2/Driver oci8.php

On 9/27/06, Lukas Kahwe Smith <lsmith@php.net> wrote:

Lukas Kahwe Smith wrote: Justin Patrin wrote:

Do you have any other DBs installed? pgsql would be good to check too.

I will check Pgsql today. Unsuprisingly pgsql and sqlite also pass. mssql should also pass, which means its only an oci8 issue. Last time I checked I did not get chunked reading of LOBs to work in oci8 either, so the simplest solution is just to retrieve the lob result immediately always (both in the buffered and unbuffered case) when the datatype abstraction is used. The chance of someone fetching a LOB he does not indent to read seems quite low. Then again LOBs by their very nature tend to be expensive. Not sure if I want to bloat the internal API with this stuff for a single RDBMS though. I will talk to Tony (maintainer of ext/oci8), maybe we can find a solution inside the extension.

By chunked do you mean reading in pieces? Isn't this the whole point of having a resource/object for LOBs? I know that the oci-lob extension supports reading of pieces of a LOB at a time. While the user should normally be reading any LOBs that are fetched, it is possible that the LOB data will be large and therefore not lend itself to buffering as it could easily fill memory. Unless the oci8 extension is completely broken with regard to LOB handling, and I doubt that it is, we should do our best to give the user a real resource to read from. -- Justin Patrin