Hi thanks for your answer I mean a request that should return a lots of row. Its exactly a large parameters under the Where In(id1,id2,...,id1000) clause. I've tried with LongReadLen but it doesn't work.
i've put a trace() function to have the log. I've noticed a freeing parameters request before the end of selectall_arrayref() execution. Not an array reference come after this freeing parameters. I'm thinking on setting up a paging of a result? what do you think about that Fida 2010/1/8 Martin Evans <[email protected]> > fida aljounaidi wrote: > > Hi > > > > I have a problem whith one large select request. > > > > A connection is opened by dbi perl but ended without giving any result. > > Th perl script end with an error like > > > > "Not an ARRAY reference" > > > > When i observed mysql log, i found that the connection opened is ended > > without any result. > > When i execute sql query directly into the db server, it succeed. > > > > i didn't find anyt ips about that. > > However i found a kind of definition of buffersize on dbi:teradata. (a > kind > > of parameter to define into dbi->connect instruction. > > > > Any idea about that? > > > > Thanks a lot. > > > > What do you mean by "one large select request" - do you mean it should > return lots of rows or a row contains a column that is very large? > > See LongReadLen for retrieving large columns. > > We'd have to see a small self contained example to diagnose where the > "Not an ARRAY reference" is coming from. > > Martin > -- > Martin J. Evans > Easysoft Limited > http://www.easysoft.com >
