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

Are you absolutely positive that you're executing the same SQL statement in both cases?

What happens when you do a select count (*) instead of select name, year, ... using the prompt and through Perl/DBI .. still the same disagreement?

--t. alex

"Nyahhh (munch, munch) What's up, Doc?" --Bugs Bunny

Comment on Re: DBI Perl Oracle , returs less number of rows than actual number Select or Download Code

Replies are listed 'Best First'.
Re: Re: DBI Perl Oracle , returs less number of rows than actual number by learn_forever (Acolyte) on May 31, 2002 at 05:18 UTC
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)	[reply]
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]