Re: Re: DBI Perl Oracle , returs less number of rows than actual number

Yes sir, I am 101% sure that the SQL is same.

Now interestingly I tried to run this using TOAD, it returns 55000 records.

I was suspecting there was some buffer size reated issue so tried to use count(*), add few more columns, drop some columns, nothing changes it rerives 30767 records.

Is there any known issue with this large number of records? Is there any setting such as CacheInSize or something?

Alternatively can anyone suggest the debugging technique to check where the record set fails? (Except for prinitng the last retrieved record)

Comment on Re: Re: DBI Perl Oracle , returs less number of rows than actual number

Replies are listed 'Best First'.
Re: (3) DBI Perl Oracle , returs less number of rows than actual number by talexb (Chancellor) on May 31, 2002 at 13:40 UTC
Alternatively can anyone suggest the debugging technique to check where the record set fails? (Except for prinitng the last retrieved record) You have tried `DBI->trace(1)` already, haven't you? --t. alex "Nyahhh (munch, munch) What's up, Doc?" --Bugs Bunny	[reply] [d/l]